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
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