Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Disable values for specific rows in a matrix

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. ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      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