Filter Column in Table1 with value from Column in Table2

mlagerweij — Mon, 10 Oct 2022 22:34:56 GMT

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],

"table2[staff]",

"0"

)

Thanks,

Mark

Re: Filter Column in Table1 with value from Column in Table2

v-xiaotang — Tue, 11 Oct 2022 09:21:42 GMT

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.

topic Filter Column in Table1 with value from Column in Table2 in DAX Commands and Tips

Filter Column in Table1 with value from Column in Table2

Re: Filter Column in Table1 with value from Column in Table2