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

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
Icon for Community Champion rankCommunity 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