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?
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])
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |