How to make a slicer to filter for multiple columns

[myou]

I have this table

ID	Member1	Member2	Score
1	John	Jack	10
2	Jack	John	20
3	John	John	30
4	Jack	Jack	40
5	Sara	Maya	50
6	Jack	Mia	60
7	Maya	John	70

I want to have a slicer that when i select two values for example 

It will show me these rows when Jack and John are working together

ID	Member1	Member2	Score
1	John	Jack	10
2	Jack	John	20

[v-frfei-msft · Accepted solution]

Hi @myou,

Based on my test, we can take the following steps to meet your requirement.

1. Create two calculated columns.

con = CONCATENATE(Table1[Member1],Table1[Member2])

con2 = CONCATENATE(Table1[Member2],Table1[Member1])

2. Create two measures as below.

Conca = CALCULATE(CONCATENATEX(VALUES(Table1[Member1]),Table1[Member1]),ALLSELECTED(Table1))

Measure = IF(MAX(Table1[con]) = [Conca] || MAX(Table1[con2])= [Conca],1,0)

3. Then we can create the visual and filter the visual based on the Measure.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/6k18se3dh2ejjzu/How%20to%20make%20a%20slicer%20to%202.pbix?dl=0

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @myou,

Based on my test, we can take the following steps to meet your requirement.

1. Create two calculated columns.

con = CONCATENATE(Table1[Member1],Table1[Member2])

con2 = CONCATENATE(Table1[Member2],Table1[Member1])

2. Create two measures as below.

Conca = CALCULATE(CONCATENATEX(VALUES(Table1[Member1]),Table1[Member1]),ALLSELECTED(Table1))

Measure = IF(MAX(Table1[con]) = [Conca] || MAX(Table1[con2])= [Conca],1,0)

3. Then we can create the visual and filter the visual based on the Measure.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/6k18se3dh2ejjzu/How%20to%20make%20a%20slicer%20to%202.pbix?dl=0

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @myou,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank

[dethompson97]

@v-frfei-msft,

What does MAX do in the IF here?  I was trying to learn from this example and replaced MAX with MIN as I thought it was just trying to determine if the comparison was TRUE and got the same results EXCEPT for the grand total in which I got a 0.  Can you help me understand why?

Thanks again for a great solution.  

Dawn