Excluding data from header totals in matrix

[Gingerjeans88]

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 2022	November 2022	December 2022
Type 1 License Totals	1000	1100	1200
Type 1 License - Distributor	800	900	1000
Type 1 License - Supplier	200	200	200
Type 1 License - Other	150	160	160

[v-zhangti · Accepted solution]

Hi, @Gingerjeans88 

You can try adding filtering to your Page.

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

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]

You can make it dynamic,

[Greg_Deckler]

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