Filter not working

[888once]

I have two tables.  One with company names, and another that has company names with key words.  I am trying to filter a matrix by the keywords, but choosing them in a slicer is not filtering down the matrix.  Relationship is set correctly.  I have made two dummy tables that are similar, and the results are the same.  What am I missing?  See below - When I click on Car, I should only get Red.

[v-zhangti]

Hi, @888once 

You can try the following methods.

Measure = IF(SELECTEDVALUE(Sheet2[Color])=SELECTEDVALUE(Sheet1[Color]),1,0)

Put measure in the filters of the view of colour and set it equal to 1.

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

The irection of your relationship shows where the filter is flowing from and to

[danextian · Accepted solution]

Hi @888once ,

Based on the screenshots, you're supposed to filter Sheet2 by color from Sheet1 but you are filtering by Type in Sheet2 which relationship doesn't flow to Sheet1.  If you want the relationship to flow to and from a table, you need to set Cross filter direction to Both. But the bigger question is why create a separate Color table if it isn't what you're going to use as a filter?

[888once]

You are backwards.  I am trying to filter sheet 1 by selecting a type in sheet 2.