Forum Discussion

kmes912's avatar
kmes912
Icon for Helper I rankHelper I
6 years ago
Solved

Aggregate Absolute Value At a More General Level

Hi, I have data that is at the unit > multiple drivers > label > date.  What I want to be able to do is get the absolute difference by day by filtering at the unit level. So below is a mock up of t...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    6 years ago

    think you need a sumx to bracket the original measure.

    AbsDiff:=SUMX(VALUES(Table2[Date]),CALCULATE(ABS(SUM(Table2[Actual])-SUM(Table2[Plan Adjusted]))))
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
6 years ago

think you need a sumx to bracket the original measure.

AbsDiff:=SUMX(VALUES(Table2[Date]),CALCULATE(ABS(SUM(Table2[Actual])-SUM(Table2[Plan Adjusted]))))