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

Measure 2 = divide(SUMX(Table2,[Measure]),SUMX(Table2,Table2[Export]))

Impactful Individual

9 years ago

Same values as I had :(

vanessafvg
Community Champion
9 years ago
divide(SUMX(Table2,[Measure]),calculate(SUMX(Table2,Table2[Export]),sku = 8510))
- Omega
  Impactful Individual
  9 years ago
  What if I have multiple SKUs?
  - vanessafvg
    Community Champion
    9 years ago
    divide(SUMX(Table2,[Measure]),calculate(SUMX(Table2,Table2[Export]), filter(table2, sku = 8510 && sku = 111))
Anonymous
Not applicable
9 years ago
Omega,

I can get your expected result by creating the following measures. How do you create visual in your scenario?

ABSDIFF = ABS(SUMX(Table2, (Table2[Export]-Table2[Import])))
ExportTotal = SUM(Table2[Export])
Measure 2 = DIVIDE(Table2[ABSDIFF],Table2[ExportTotal])

Regards,
Lydia Zhang
- Omega
  Impactful Individual
  9 years ago
  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.
  - Anonymous
    Not applicable
    9 years ago
    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