Forum Discussion

prajaktakeni11's avatar
2 years ago

Organizational hierarchy RLS level 2 without path function

Hello
I want to create RLS such as manager can see team members data (2 level below him ) in orgnizational hierarchy
however in my case my there are some values in my "ManagerUID" column which are not present in "EMPUID" Column because of which I cannot use PATH() funtion
For 1 level I have used following RLS dax
[UID] = left(username(),6) || [LineManagerUID] = left(username(),6) || [Email] = username() || [LineManagerEmail] = username()
Please help me to craete level 2 RLS
Thank you in advance