Filter out blanks in Subtotal rows in Matrix visualization

[mybarbie9917]

Hello everyone, 

I need to filter out blanks of Subtotal rows in a Matrix. In the below screenshot, the Subtotal row "##CLIENT LOST##" is blank, so I want to hide it. Even though the Subtotal row "MORNEAU SHEPELL INC" contains a blank row "MORNEAU SHEPELL", the Subtotal is not blank, so I want to keep it. 

I appreciate any help.

Thank you!  

[v-jayw-msft · Accepted solution]

Hi @mybarbie9917 ,

Create a measure as below and add it to visual filter.

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[id]))

 

Best Regards,

Jay

[pranit828]

HI @mybarbie9917 

Create a measure on the same subtotal calculation and use it in filter pane to filter all blanks.