Unique values in Slicer to search for exact match in a comma separated column

[KennyInDC]

Hello Everyone!

This is my first time posting, so I hope I'm clear..... I'm trying to make a interactive tool for employees so they can find out which combinations of data items are considered low/medium/high risk.

I have 2 tables.  The first table tells us different data types. The second table tells us the different data type combinations, and their resulting severity.

I want a slicer to display the different data names (or codes) from the first table. When users select a combination of data types from the slicer, an exact match will display the result column from the second table. 

Example - In the slicer, if someone selects "A," nothing should happen because there is no match in the "Combinations" column.  But if they select "A" and "B" at the same time, I want to see "Caution."  If they select "A","B" and "C" at the same time, they should see "Alert," and so on... 

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhjx3D0SDzkjEbmls?e=bi9Vdr
be careful, I noticed that your letters in the first table do not match the letters in the second table.
for the measure to work, there must be a match

[KennyInDC]

Thank you!  You are a true PRO, and you have saved me.  

[amitchandak]

@KennyInDC , refer if this on the similar issue can help

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[KennyInDC]

Thank you.  I have been able to accomplish this, but I don't think it's quite what I'm looking for. 

In my example, if a user selects both A and B on the slicer, I want it to display the exact match in the "Combinations" column (only display the row with A, B).  

  

I don't want to see all rows where A & B exist, I want to see only rows with an exact match of A, B.