RLS for Multiple Dimension Tables

[Anonymous]

We set up dynamic RLS using a security view (WC_SECURITY_G_VW) that has employee info (including UPN) and the projects that the employee is assigned to. We then  join this to the Project Attributes table and tie it into our fact table (Cost Data). For the RLS setup, we set the upn field from WC_SECURITY_G_VW = USERPRINCIPLENAME() and it works great. However, when people look at data from one of the dimension tables, they see all the data and it's only restricted once they pull in something from the fact table. What we want to happen is that when someone pulls down data from one one of the dimension tables (Task Code for example), they only get the tasks that the user has access to based on WC_SECURITY_G_VW. I first tried doing bidrectional relationships from the other dimension tables to the fact table but you can't do that on every dimension table. So I'm guessing I'll have to add some DAX for the RLS setup on each dimension tables. I've tried different DAX but so far haven't got it to work how I want. Any help would be appreciated. A screenshot of the model is below.

[olgad]

Hi, I am writing a series of several blogs now on RLS, do you think you can you ping me your report in private messages i will take a look and give you a suggestion.