Filter Column in Table1 with value from Column in Table2

[mlagerweij]

Hello, 

I have a Table2, which contains a list of staff members. Table1 is a spreadsheet containing projects and the staff members assign to it. How can I use the column value from table2 to filter the assignee column in table1 using a slicer. 

I have been playing around with creating a new column with some DAX to get it to work, with little success. 

So, say that in this case I just want to see 'Winnie' or 'Raymond'

  

I have tried some different things, but to no avail. Appreciate any insights someone might give me.

_Test4 =

IF (

    SEARCH (

        table2[staff],

        Table1[Assignees],

        1,

        0

    ),

    "table2[staff]",

    "0"

)

Thanks,

Mark

[v-xiaotang]

Hi @mlagerweij 

Thanks for reaching out to us.

>> So, say that in this case I just want to see 'Winnie' or 'Raymond'

what does this mean? When you filter something in the filter, what data do you want to appear in the table visual?

Best Regards,

Community Support Team _Tang

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