Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to set up RLS by the manager's hierarchy.
Inside the table, I have created additional columns with the managers' hierarchy level.
The data looks like this:
USER | PARENT | PATH | MANAGER_1 | MANAGER_2 | MANAGER_3 | MANAGER_4 | MANAGER_5 |
Where manager levels 1-6 are the PATHITEM # 1 to 6.
Now I am trying to set up RLS with the next DAX:
SWITCH(TRUE(),
USERPRINCIPALNAME() in VALUES([manager_6]), [manager_6] = USERPRINCIPALNAME(),
USERPRINCIPALNAME() in VALUES([manager_5]), [manager_5] = USERPRINCIPALNAME(),
USERPRINCIPALNAME() in VALUES([manager_4]),[manager_4] = USERPRINCIPALNAME(),
USERPRINCIPALNAME() in VALUES([manager_3]),[manager_3] = USERPRINCIPALNAME(),
USERPRINCIPALNAME() in VALUES([manager_2]),[manager_2] = USERPRINCIPALNAME(),
USERPRINCIPALNAME() in VALUES([USER]), [USER] = USERPRINCIPALNAME())
But I get an error in RLS window:
The VALUES function expects a column reference expression or a table reference expression for argument "1"
I tested a measure with the formula and I works ok.
I can't figure out what is wrong.
Solved! Go to Solution.
I found the workaround.
Instead of using VALUES in RLS window, I used an additional measure for filtering:
I found the workaround.
Instead of using VALUES in RLS window, I used an additional measure for filtering:
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |