In setting up Row level security, I am trying to have two filters, each for a separate table, for one role. Currently, I have two tables: Projects (listing all projects, owners, location and start/end dates) and Project Time (listing all projects, employees, time spent, and date. Both tables are have a relationship connected by Project ID.
I am setting up roles and have users that need access to their time spent but also data for Projects in locations they are assigned. For example, the user would see their time and all other employees' time spent on projects in their location. However, the separate filters are just compounding and the user can only see their hours spent on projects in their location. The following are the DAX expressions I have for their filters. Please confirm if this achievable via dax and not adding a separate column for emails.
User1:
- Table1 - Project table: [Location] = "NYC"
- Table2 - Project Time table: [Employee] = "User 1"
I'm not sure this answers the question directly, but I would approach this as follows.
Create two roles (one for location and one for employee) and assign users to both. The end users should be able to see data according to all roles they are assigned.