Dynamic Row Level Security Profit and Loss

Power BI
1

Hi Experts

Please see the data model.

Dynamic RLS Data Model.xlsx (15.7 KB)

These are the tables I have in my data model.

Table 1: Profit and Loss Actual
Table 2: Profit and Loss Budget
Table 3. General Ledger
Table 4: Calendar
Table 5: Job Code ( 50 job Code )
Table 6: Staff Table

I wish to create a Row Level Security.
Certain employees have access to certain job. So when they log in they should only have access to the jobs they were given access to. There are 50 job codes. So creating 50 Static Row Level Security is not possible. Moreover some people will have access to all jobs and some will have access to multiple jobs.

Regards,
Raj