Forum Discussion
Solved
Absolute at total
Dears, I am currently trying to calculate the absolute difference between imports and exports at SKU level in the total. For the same SKU, I have imports and exports in every week. At the end of ...
Omega,
Create the following measures and check if you get expected result.
NewMeasure = IF(COUNTROWS(VALUES(Table2[SKU]))=1,Table2[ABSDIFF],SUMX(VALUES(Table2[SKU]),[ABSDIFF]))
Measure 3 = [NewMeasure]/[ExportTotal]
Regards,
Lydia
Omega,
What do you mean that "combine SKUs"? Could you please post the screenshot that how you create the visual and how are the incorrect value like?
Regards,
Lydia Zhang
Sorry I was on leave and couldn't reply any time soon. What I meant is to get the difference between exports and imports for each SKU and take the summation for this difference.
In PBI, it doesn't take the difference at SKU level but at the lowest level which is in this case is Weeks. Due to that, the calculations are not correct.