Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX for Row Level Security

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.