Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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!
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.
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!
This worked perfectly. Thank you!
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |