Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper 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.

ktt777's avatar
ktt777
Icon for Helper V rankHelper 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.