Dynamic RLS for users based on a column value with non-unique values

Hi Adam01,

You are almost there with the RLS setup.
What you need is the ability to filter a table by the User that then filters another table (through a relationship) to identify which department they belong to. This last table would then be used to filter all other data (using relationships).

Something like this:

This allows for the following RLS setup to be made:

RLS Role definition used:

You can even merge the RLS table and the Staff Department table into one and apply RLS on it.

Here is the Link to the file I used: Dynamic RLS for users based on a column value with non-unique values.pbix

Did I answer your question? Mark my post as a solution!