Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hide matrix rows without affecting values

Hi,   Is there a way I can hide rows in a matrix without affecting the value? Or get my measures to ignore the visual filters? Context: I only want to see suppliers which have failed but whe...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may try ISINSCOPE.

    Measure =
IF (
    ISINSCOPE ( Table1[Column1] ),
    SUM ( Table1[Column2] ),
    CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1[Column1] ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You may try ISINSCOPE.

Measure =
IF (
    ISINSCOPE ( Table1[Column1] ),
    SUM ( Table1[Column2] ),
    CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1[Column1] ) )
)