How do I subset rows of a table

[Anonymous]

Im using a grouped by table like this:

Sales Center	Sales Doc	Outlier 1	Outlier 2
A	123	1	0
B	456	1	0
B	789	1	1
C	112	0	1

To create a bar chart of distinct count of sales doc numbers by profit center. I want to add a slicer with options Outlier 1 and Outlier 2

I want to subset the table above by the options on my slicer. For example: If I select Outlier 1, I want the first three rows in my table (with a value of 1) and my bar graph to use the new subset of the table. 

I'm very new to Power BI, and I'm trying to do this with a Switch Statement Measure but it's not working. If anyone has started code for this I would very much appreicate it.

[Anonymous]

@Anonymous  how are you getting the value of outlier1 & outlier 2 

Kindly provide the sample PBIX file .

[camargos88]

Hi @Anonymous ,

Check if the attached file helps you.

I've unpivoted the outliers columns and filtered the page to get only values with 1.