Forum Discussion

mhsk's avatar
mhsk
Icon for Helper II rankHelper II
6 years ago
Solved

filter matrix to show only negative values

Hi, I would like to ask you for advise if it is possible to filter only items that have minus in matrix? im interested in only those where minus will appear (in any week).   what i have:   ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi mhsk ,

     

    Create a new measure as below to work on it.

    Measure 2 = IF([Measure]>=0,BLANK(),[Measure])

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi mhsk ,

 

Create a new measure as below to work on it.

Measure 2 = IF([Measure]>=0,BLANK(),[Measure])

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your help!