Forum Discussion

ktt777's avatar
ktt777
Helper V
5 years ago
Solved

Mutiple filter

hi all

 

Below is my raw data. How can i create a matrix in power bi to show a table with process have at least 1 value ( Start, Mid, End) is negative ?

 

thanks

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ktt777 

    Try to build a measure and add this measure into filter field in this matrix visual.

    Measure:

    Filter Measure = 
VAR _Start = IF(SUM('Sample'[Start])>=0,0,1)
VAR _Mid = IF(SUM('Sample'[Mid])>=0,0,1)
VAR _End = IF(SUM('Sample'[End])>=0,0,1)
RETURN
_Start+_Mid+_End

    Add this measure into filter field in this matrix visual and set this measure to show items when value is greater that 0.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • ktt777's avatar
      ktt777
      Helper V
      5 years ago

      hi amitchandak 

       

      Here is the expected result. It show process A, C because there is at least 1 value is less than 0 in the row

       

      thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi ktt777 

        Try to build a measure and add this measure into filter field in this matrix visual.

        Measure:

        Filter Measure = 
VAR _Start = IF(SUM('Sample'[Start])>=0,0,1)
VAR _Mid = IF(SUM('Sample'[Mid])>=0,0,1)
VAR _End = IF(SUM('Sample'[End])>=0,0,1)
RETURN
_Start+_Mid+_End

        Add this measure into filter field in this matrix visual and set this measure to show items when value is greater that 0.

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.