Forum Discussion
Row Level Security in an Org Chart
I have done that for you already in the sample file.
In modeling---> manage roles ---> create a new role and use the dax as used in the sample file provided above.
See if you are able to do it
And you can make use of "Path" and "PathItem" to get the heirarchy -PATHITEM Function DAX - SqlSkull and then use it to apply dynamic Row Level Security.
Check out these links to implement dynamic RLS:
Power BI – Dynamic Row Level Security – Tips to get it working! - oxcrx34285
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Would you mind giving me a sample DAX to use PATHITEM correctly? I appreciate your links and understand conceptually but could use an example. Thanks!
Here you go.
I have made use of PATHITEM and PATHCONTAINS(in Manage Roles).
Also please have an email column if you want to use UserPrincipalName()
Thanks this is helpful! Now how would I create a way to filter a table for all of Steve's reports or Sal's reports in the same field?
For example, how would I use the Hierarchy field to show Steve's reports when I want to create Steve's version, or Sal's reports when creating Sal's version?
I have done that for you already in the sample file.
In modeling---> manage roles ---> create a new role and use the dax as used in the sample file provided above.
See if you are able to do it