Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Trying to figure out a way to total the Absolute Value of Routing Guide Variance column in this table to totals based on the X_LANE_GID in a new column to the right. So in this case the total should be 2.03+0.25+2.08+3.31+5.41+2.39 = 15.48
So in my desired new column to the right, I will have 15.48 at the row level for that specific X_LANE_GID of LOL.544-604
How it should look:
The DAX formula I have seen that could work is
=CALCULATE(SUM(Table1[Value]),ALLEXCEPT(Table1,Table1[Category]))
But given that the Abs Value of Routing Guide Variance is a calculated meaure (quick measure), the sum function does not read this as a valid field to sum.
If anyone has a solve to this, very much appreciated.
Thanks,
AB
Hi @ABBrewin
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
@ABBrewin , Try like
=CALCULATE(SUM(Table1[Value]),ALL(Table1))
Hi,
Does this measure work?
=CALCULATE([Abs Value of Routing Guide Variance],ALLEXCEPT(Data,Data[X_LANE_GID]))
If it does not, then share the link from where i can download your PBI file.
Thanks Ashish,
Close, but looks to total incorrectly to the actual sum in the Abs Value of Routing Guide Variance column. I also have filters if that makes a difference
Would like to see it total correcty AND flow with the filters. When I filter on the month of May it looks to keep the 261.61 stagnant
Let me know if you can diagnose this given the above
If not, I can generate a link to my report for you
Hi,
Share the link from where i can download your PBI file.
Try this @Ashish_Mathur
Let me know if it's restricted for some reason. Table I'm referring to in the question is on the Routing Guide Compliance tab on the right side of the visualization screen.
Thanks,
AB
Hi,
That page brings up a sign-in prompt.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |