Only selected rows in matrix without filtering total

[Repjas]

I have a table like below. I want to create a matrix that shows only certain subcategories and segments, because there are way to many. I want to the matrix to also show the total category value.

Category	Subcategory A	Segment 1	100
Category	Subcategory A	Segment 1	120
Category	Subcategory A	Segment 2	200
Category	Subcategory B	Segment 2	300
Category	Subcategory B	Segment 3	100

Matrix should look like this:

Category - 820

   Subcategory A - 420

       Segment 2 - 200

So basically, I just want to 'hide' certain rows. I can't do it using filters, because then the total category does not add up. I also tried with excluding rows in the matrix, but that also affects the highest level. Is there a way to do it?

[Greg_Deckler · Accepted solution]

@Repjas Couple options, use the Filters pane to filter out things but construct a measure where you ignore those filters in the Total row. See below. The other way, construct a measure that returns BLANK() if you are not in Category, SubcategoryA or Segment 2

See my post here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...