Forum Discussion

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful 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 ...
Need Help
  • Anonymous's avatar
    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

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

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

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
9 years ago

Can you please ellaborate further?

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    SUMX(Table2,ABS(Table2[Export]-Table2[Import])) * -1

     

    (but like i say i could be being daft)