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
Anonymous
Not applicable

How can I get the total of a matrix group inside of the subgroups?

I want 5750 to display in all of the rows in subgroups.
MicrosoftTeams-image (1).png

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Anonymous whatever measure 3 is just wrap it with
CALCULATE([Measure3], REMOVEFILTERS(Table[SubCategoryColumn]))

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@Anonymous whatever measure 3 is just wrap it with
CALCULATE([Measure3], REMOVEFILTERS(Table[SubCategoryColumn]))

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂

Anonymous
Not applicable

Thank you so much! It worked.

@Anonymous my pleasure. Please don't forget to mark that comment as a solution so other members will find it more easily

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.

Top Solution Authors