Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
4 years ago
Solved

Hide row in Matrix without affecting total

Hello,

 

thought it is easy but didnt work 🙂

 

I want to hide some values without affecting the total.

 

In detail: Hide BA, BB, BC but keep the Total 36 and 42:

 

 

The Measure is something like CALCULATE ( SUM ( ) ... , LASTDATE ( ) ). 

 

I tried some DAX with ISINSCOPE but didnt work.

 

Thanks.

 

Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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

1 Reply

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    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