RLS: Users with multiple roles filter problem

Hi v-alq-msft 

Thank you for taking the time to review and create the small example. 

I was also considering your approach, but since I have 20+ Companies and around 10 Departments, I would like to avoid as much as possible to create roles for all different possibilities of Company+Department. Another issue is that your approach needs to be applied at the fact table, where I would like to apply them at the dimension tables so the filters of the report get also filtered with relevant information. Applying to the fact table would require me to enable bi-directional filters and I would like to avoid it.

Being able to assign multiple roles to users is very helpful at avoiding this situation, as it will avoid a lot of work and maintenance in the future.

Thank you

Kind regards,