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

     

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

This is a bit different scenario. please put your measure as value, weeks as column and any other dimention that measure impacts  (part, etc) in row. Thing is measure filter will work for total measure value <0 and im looking for to see measure values <0 for each week / each part.

 

So to cut the long story short im just looking to see all items (rows) where measure was <0 at any week (like on this picture):

when there was an event = measure<0  it is coloured in red and i just want to see items impacted by red. doable?

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your help!