Sum ABS Variance Measure

[Beezer70]

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.

[jdbuchanan71]

@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 · Accepted solution]

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]

This worked perfectly.  Thank you!