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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Gingerjeans88
Helper IV
Helper IV

Excluding data from header totals in matrix

Hello all, 

 

I am building a report for a client and have shown their numbers in a matrix. They want to see number of licenses sold by category (Distributor, Suppliers etc), and then those categories are grouped into top-level headers by type. However, they don't want to include all of the component lines. 

For example, in the below table the Type 1 License totals (top level of matrix) should only include Type 1 License Distributor and Supplier totals, and not the 'Other' (apologies for layout but obviously can't add a matrix here and can't share my pbix). 

 

Obviously we could just add separate visuals and filter this out where needed, but this gets messy when cross-visual filtering.

 

How do we achieve this? Is there some smart option we have not thought of?

 

 October 2022November 2022December 2022
Type 1 License Totals100011001200
Type 1 License - Distributor8009001000
Type 1 License - Supplier200200200
Type 1 License - Other 150160160
1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Gingerjeans88 

 

You can try adding filtering to your Page.

vzhangti_0-1667894159181.png

At this point, the View of the Other no longer appears on this page.

vzhangti_1-1667894201653.png

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @Gingerjeans88 

 

You can try adding filtering to your Page.

vzhangti_0-1667894159181.png

At this point, the View of the Other no longer appears on this page.

vzhangti_1-1667894201653.png

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CNENFRNL
Community Champion
Community Champion

You can make it dynamic,

CNENFRNL_0-1667849656601.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Greg_Deckler
Super User
Super User

@Gingerjeans88 Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors