Conditional/Multi-Layered Row-Level-Security

[PMXMX]

Hi Power BI Community,

I am having trouble figuring out a multi-layered, dynamic RLS problem. Essentially, I have a table of transactions and employee email adresses. I also have another table of employee emails and their departments.

Depending on which department the user belongs to, I want to provide them with either:

1. Access to their own transactions only
2. Access to 1 or more department's transactions

How do I go about implementing this?

[amitchandak]

@PMXMX , You need to have a department dimension. And Department should be filtered using department email table and on department email table configure rls role

email = userprincipalname()

Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc