Forum Discussion

Impactful Individual

9 years ago

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 ...

Anonymous
9 years ago
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

Community Champion

9 years ago

divide(SUMX(Table2,[Measure]),calculate(SUMX(Table2,Table2[Export]),sku = 8510))

Impactful Individual

9 years ago

What if I have multiple SKUs?