Security Filter question

Ok I understand the basics of security filters but I am having trouble wrapping my head around multiple security filters.

Here is what I am looking at.

Multiple sales reps in multiple cities, I have a user table that has the City in a column called [Branch] with 3 options, City 1, City 2, and All. Then I have a list of things with a [Branch] column.

How do I formulate the expression so the reps only see what city they are working with?

0 1 64
1 REPLY 1

If you are filtering the employees table with the security filter like [Email]=USEREMAIL(), then you could write the formula like IN([Branch],Employees[Branch])

Top Labels in this Space