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
maybe im being daft but why dont you convert the number after you have done the calculation rather than creating absolute figures before you do the sum. ie. * -1
Can you please ellaborate further?
SUMX(Table2,ABS(Table2[Export]-Table2[Import])) * -1
(but like i say i could be being daft)