Hide rows in matrix table without affecting subtotal

[dokat]

Hi,

Is it possible to hide rows in matrix table without affecting subtotals and impacting other visuatizations?

In below table i dont want to show row totals for Tier 4 but subtotal to still add up to 600. When i use filters subtotal also exclude the filtered value because of that it doesnt work. Are there a workaround this?

	Sales
Tier 1	100
Tier 2	150
Tier 3	170
Tier 4	180
Subtotal	600

[dokat]

@TomMartens  Yes this worked. Thanks

[TomMartens]

Hey @dokat ,

maybe this measure provides what you are looking for:

Sales w/o Tier4 = 
IF( SELECTEDVALUE( 'Sales'[Tier] ) = "Tier 4"
    , BLANK()
    , SUM( 'Sales'[Sales] )
) 

It seems that the below table visual provides what you are looking for:

Hopefully, this provides what you are looking for.

Regards,

Tom

[Nivedhana]

This worked for me! Thanks!! 

[dokat]

@TomMartens Thanks but i am trying to completely hide row where Tier + Tier 4. Not just the sales amount.

[TomMartens · Accepted solution]

Hey @dokat ,

basically, you can't hide something, Tier 4 is shown in my sample because of this property

If you deactivate the property Tier 4 will be automatically "excluded" from the row headers.

Regards,

Tom