Forum Discussion
Absolute at total
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
It's close but when you combine SKUs it won't give the correct value because PBI will calculate the difference at week level then sum up the difference at SKU level. My aim is to calculate the total exports and imports per SKU -> Apply ABSDIFF -> Sum ABSDIFF and the divide by total exports.
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
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,
LydiaSorry 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.
Thanks a lot!!! This is the solution I was looking for :D