Compare lists to produce yes/no for slice

[JLC]

Hi,

I have tried to find a solution in posts but I cannot figure out how to do this correctly.  I have a Current_User() slice on my Users Table with roles and several other columns. One column in Users is a enumlist (ref) of Cost Centers.  A user could have 1 or more Cost Centers.  I have another table Projects that stores ProjectCostCenter. Each project could also be 1 or more in an enumlist (text).

My slice I am trying to create is for the User to only see Projects that have a match any cost center in his lists of cost centers.

I am not sure how to produce a yes/no for two lists and slice the projects for the matching records

[JLC · Accepted solution]

I finally was able to find a solution that worked after searching posts.

Not(List()= Intersect(ANY(Current_User 2[CCNumber]),[ProjectCostCenter])

[ThisIsIdrees]

Perfect 👌