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 and produced quantities are each measures that calculate from separate data sources.

 

Gap (SY) = ([Produced SY] - [Planned SY])

Gap (SY - ABS) = ABS([Produced SY] - [Planned SY])

 

I need to sum the Gap (SY - ABS) column, but what I am getting is the absolute value of the Overall Variance.

 

 

In this example the Gap (SY - ABS) total should be 4,865 instead of 4,829.

 

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!

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    2 years ago

    Beezer70 

    Try it like this.

    GAP (SY - ABS) = SUMX ( VALUES ( YourTable[Work Orders] ), ABS ( [Gap (SY)] ) )

    This will convert the [Gap (SY)] to ABS then add them up.

  • 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!