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.
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

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

3 Replies

  • 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