Filter Matrix for first level of matrix only

[wiselyman3]

Hi All, 

I am trying to filter this matrix to only include values greater than 1 for the first row heirarchy. However, when I drill down using the plus button, I still want to see those totals that may equal 1. Below is an example table: 

So, in this example, I would want to filter out "Tim" while still being able to see the others. I want to filter by the group total, not the subtotals.  Thank you for your help!

[Greg_Deckler]

@wiselyman3 Sounds like a Complex Filter like IF( ISINSCOPE( 'Table'[Name] ) && [Count of Name] = 1, 0, 1 )

The Complex Selector - Microsoft Fabric Community

[wiselyman3]

@Greg_Deckler , the Count of Name value in the Matrix is not an actual Measure, its just one of the default aggregations when i put this field into the matrix "Values". So the && [Count of Name] is not working here

[Greg_Deckler]

@wiselyman3 Just replace with COUNT('Table'[Name]) or COUNTROWS maybe.

[wiselyman3]

Apologies @Greg_Deckler but I am still not sure how to execute this and make it filter the matrix. I have the measure written, but cannot get any farther than that currently