Mutiple filter

[ktt777]

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

[amitchandak]

@ktt777 , can you share expected output

[ktt777]

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 · Accepted solution]

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.