DAX for Row Level Security

[Anonymous]

I am trying to implement Row Level Security and need some help here.

I have 2 datasets and they both have diffent sets of people under their Org.

However , Instead of passing the org structure in the DAX .. I wanted to see if I can come up with a role where I only mention to look at either Level4 or Level5or level6 in both datasets and bring the data for respective levels.

example  Table1[Level4] = Table2[Level4] OR

Table1[Level5] with Table2[Level5]

Then all pages can show different data based on the Level that logs into the report.

Any help on this will be appreciated.

[v-easonf-msft]

Hi , @Anonymous 

I'm a little confused by your description.

Faking some data as a sample will greatly help us understand.

Best Regards,
Community Support Team _ Eason

[amitchandak]

Refer

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...