Forum Discussion
RLS Filtering additional dimensions
- 8 months ago
Hi Chewdata
Your approach is correct; you need to add restrictions for Behandelaren and Reviewers to the RLS role, but the expression you used is wrong.
You should first filter out the Teams permissions that the current user has, and then use those items to restrict Behandelaren and Reviewers.
In short, you need to change Behandelaren[Team] IN VALUES(Team[Team]) to:
VAR AccessTeamItems = CALCULATETABLE( VALUES(RLS[Team]), RLS[UPN]=USENAME(), ALL() ) RETURN Behandelaren[Team] IN AccessTeamItems // Reviewers[Team] IN AccessTeamItemsDid I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Hii Chewdata
Add separate RLS rules on Behandelaar and Reviewer tables using [Team] IN VALUES(Team[Team]) so they inherit the same Team restriction created by the UPN filter on the Team table; this is the cleanest and supported way to make the slicers show only employees from the user’s own team.