How to add visual filter if the criteria is measure?

[ericbi]

I have below table in BI need to add a filter of status.  

the status is dynamic,  for example, if the selected month's profit - same month last year is possitive, then the status is Retained+, otherwise it's Retained-, etc.  I can get the dynamic status per selected period in below table.  now i need to add a filter to let user select the status they want to see,  I saw I could filter the status in visual level filter by typing the key words but I could not add it to the filter list.  I created a table with all the status and I would like to know how to link them to the dynamic status and let them interactive.  

[v-chuncz-msft]

@ericbi,

Add an additional measure and take advantage of Visual level filters..

Measure =
IF ( [Selected Period Status] IN VALUES ( Table2[Selected Period Status] ), 1 )

[ericbi]

Hi Sam, 

I created a Measure = IF([Selected Period Status] IN VALUES('Status List'[Selected Period Status]),1)

[Selected Period Status]  is the result in the table,  Status List'[Selected Period Status] is in the list I selected.  I'm not sure how to link this to the visual level filter.  you can see when i select Retained -  it gives me the result is "1".  if I select other options, it gives me 0.  not sure what to do now. 

[v-chuncz-msft]

@ericbi,

Drag it to the table visual as well.

[ericbi]

I drag the measure to the visual filter but show me this.  

[v-chuncz-msft · Accepted solution]

@ericbi,

Just set Show items when the value is 1.