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 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

 
Need Help

7 Replies

  • 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

       

       

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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!