Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ABBrewin
Frequent Visitor

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

 

PowerBI question.PNG

 
 

How it should look:

 

New Column.PNG

 

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

 
7 REPLIES 7
v-diye-msft
Community Support
Community Support

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!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
amitchandak
Super User
Super User

@ABBrewin , Try like

=CALCULATE(SUM(Table1[Value]),ALL(Table1))

Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

Total Sum.PNG

 

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

 

May.PNG

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Try this @Ashish_Mathur 

 

https://app.powerbi.com/groups/me/reports/32b415d1-4452-4653-ace4-9f1206890624?ctid=21ab97d7-8e75-40...

 

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.