I have two different data sets "Shipment" and "Sales" with a common key "Fruit". What I specifically want is have Sales and Shipment columns match when there are values and null.
Example:
So I made a measure that does the IF statement. HOWEVER, the subtotals in the above example shows "3" instead of "2" for the IF statement column. I tried doing a sumx values, and countless other ways but I cannot get the subtotals to match. Below is the link.
Power Pivot Problem.xlsx
Any solution that follows this same logic would be amazing. NOTE: Lets assume I cannot change the pivot table data sets at all and can only manipulate via powerpivot.
Example:
Fruit | Ship | Sales | If Ship is Blank Statement, else Sales |
---|---|---|---|
Apple | 2 | 1 | 1 |
Orange | 1 | ||
Banana | 2 | 1 | 1 |
Power Pivot Problem.xlsx
Any solution that follows this same logic would be amazing. NOTE: Lets assume I cannot change the pivot table data sets at all and can only manipulate via powerpivot.