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
PC2790
Community Champion
Community ChampionAnd 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