Hide row in Matrix without affecting total

Hey Pikachu-Power ,

you can check if column 2 is in scope with the ISINSCOPE function and return BLANK in that case and otherwise your measure.

The following approach should work, just replace the SUM at the end with your measure:

Measure No Details = 
IF (
    ISINSCOPE ( myTable[Col2] ) && MAX ( myTable[Col1] ) = "B",
    BLANK (),
    SUM ( myTable[Measure] )
)

Then the measure will give according results:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic