Forum Discussion

mlagerweij's avatar
mlagerweij
New Member
3 years ago

Filter Column in Table1 with value from Column in Table2

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

 

 

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    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.