Matrix table filtered by multi-select slicer

[Anonymous]

Hi 

I have a scenario where i have employees attemting several different tests multiple times. They are marked P for pass , F for fail. 

I have a matrix visual like below and a multi-select slicer on the test type. 

How can I display the employees passed  ONLY selected tests from the slicer? 

For example, if i select Test A and B, I need to display the employees who passed Tests A and B both.  If I select Test A , C and E, I need to display the Employees passed those 3 tests only. Your help is greatly appreciated.

Employee	Test A	Test B	Test C	Test D	Test E
1	P	P	F	P	F
1	F	F	F	F	P
2	P	F	F	P	P
2	P	F	P	P	P
2	F	P	F	F	P
3	F	P	P	F	F
4	P	F	P	F	F
5	F	P	P	F	P
5	F	F	P	P	F
6	F	F	F	F	F
6	F	F	F	F	F
7	F	F	F	F	P
8	P	F	F	F	P
9	F	P	P	F	F
10	P	F	F	P	F
11	P	P	F	F	F
12	F	F	P	F	P

[V-pazhen-msft]

@Anonymous 
You first need to unpivot the test column. This blog explained it step by step. You may also check my pbix if needed.
Dynamic Attributes In A Power BI Report | P3 Adaptive

\

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-pazhen-msft 

I can already do this , what I am after is , in the above example, the matrix should only show Employee no 2, because that is the only one passed 3 selected tests.  It is not passed A OR C OR E, I would like to show employees  passed A AND C AND E only.

Thanks Ilky

[Anonymous]

@AlexisOlson, are you able to help me with this ?

[Anonymous]

One more point to above question, an Employee can take the tests multiple times.

Thanks

Ilky