Organizational hierarchy RLS level 2 without path function

[prajaktakeni11]

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

[lbendlin]

Either fix your hierarchy data or use dynamic RLS.

[prajaktakeni11]

@lbendlin 
thank you for your reply.....can you help me out with dynamic RLS as I ma new to RLS

[lbendlin]

Dynamic Row Level Security with Power BI Made Simple - RADACAD