Forum Discussion

ABBrewin's avatar
ABBrewin
Frequent Visitor
6 years ago

Total for a Category based on a Calculated Measure

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 to...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

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.

ABBrewin's avatar
ABBrewin
Frequent Visitor
6 years ago

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