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

 

dimperio's avatar
dimperio
Frequent Visitor
4 years ago

This is not actually 100% an accurate solution. As you can see, the total of the matrix is blank as well. The positive values had been hidden, but not removed from the calculation.