Disable values for specific rows in a matrix

[SanketBhagwat]

Is there a way I can disable the values for specific rows in a matrix visual?

Lets say I have 4 rows in my matrix and I want to show the value just for the 3rd level.

See attached screenshot.
bomqty is basically a SUM(bomqty) and second column is its Average.

I want to show the value 40,524 just for 'COLLAR, BOBTAIL HUCK, BTC5-R12GAHL PART SHOWN ON ALCOA 10660' this level and return blank for all other rows.

Thanks,
Sanket

[PaulDBrown]

You ca use the ISINSCOPE function. Something along the lines of (Let's say the level you wish to display is Table[display]):

Show = IF(ISINSCOPE(Table[display]), [your measure])

[SanketBhagwat]

@PaulDBrown Thanks for the solution. It helped me for the above test but need to hide the lower level too.

[PaulDBrown · Accepted solution]

This should work (see the structure of the rows to follow the flow of the measure):

Filter matrix rows =
IF (
    ISINSCOPE ( 'DIM Product Ref'[DProduct REF] ),
    BLANK (),
    IF ( ISINSCOPE ( 'DIM Item'[Item] ), [Sum of Sales], BLANK () )
)

So basically you are writing the IFs from the lowest hierarchy up