Forum Discussion
Row Level Security in an Org Chart
Hello. I have a table representing all people in an organization, and who they report to. See below: Manager Person Associate ID Bonus Steve P Mitch M 1235 $50 Steve P Justin S 1...
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
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