Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
78 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |