Forum Discussion

Beezer70's avatar
Beezer70
Frequent Visitor
2 years ago
Solved

Sum ABS Variance Measure

I have two fairly straight forward Variance Measure.  One is to calculate the gap between the Planned and Produced Quantites.  The other is to get the Absolute Value of that Variance.  The planned an...
Need Help
  • BITomS's avatar
    BITomS
    2 years ago

    Hi Beezer70 ,

     

    Try this measure for the ABS:

     

    Measure =

    VAR _Tbl = SUMMARIZE('Table','Table'[Work Orders],"ABS",ABS([GAP (SY)]))
    RETURN

    SUMX(_Tbl,[ABS])

     

    Hope this helps!

BITomS's avatar
BITomS
Solution Supplier
2 years ago

Hi Beezer70 ,

 

Try this measure for the ABS:

 

Measure =

VAR _Tbl = SUMMARIZE('Table','Table'[Work Orders],"ABS",ABS([GAP (SY)]))
RETURN

SUMX(_Tbl,[ABS])

 

Hope this helps!

Beezer70's avatar
Beezer70
Frequent Visitor
2 years ago

This worked perfectly.  Thank you!