How to Filter by Risky Milestone in Matrix

[Anonymous]

Hi everyone, when I try to set up the filter by "Severity", the matrix visual only shows the risky milestone in the project and filter out the other healthy milestone (green colour). What I want to do is making a filter to show all the milestone in a project whose one of the milestone is risky (red colour). May I know how to solve this issue. 

1 = red (risky) ; 2 = green (healthy)

P.S. other than 1 and 2, you may just ignore the other number

Grateful for solution from any Power BI talent.

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

According to your description, it seems that you want to show all Project Names which has at least one risky.

I have built a data sample:

Then create a flag measure:

Flag = 
var _t= SUMMARIZE(FILTER(ALL('Table'),[Project Name]=MAX('Table'[Project Name])),[Severity Number])
return IF(1 in _t,1,0)

And apply it to visual-level filter pane, set as "is 1". Below is the final output:

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

[Dhacd]

@Anonymous 
Can you share a sample data set here?

Regards,
Atma.