RLS path calculation

[syasmin25]

Hello, 

I am pretty new to RLS and have been trying to implement it in a certain way. 

My table above is a sample. I am trying to create RLS here based on the levels. Normally I can create 3 roles for 3 levels where, 
Level 1 is regular employees
Level 2 is supervisor of employees 
Level 3 is the manager/head of the building (based on the BuildingID)

I am trying to create RLS where the manager (Level 3) will be able to see the data for people below them by filtering through. For example when the manager of BuildingID='233' logs in, they can filter through the report to see people they are assigned to. 

It would be clickable in the filter pane. However, I am more used to on doing DAX calculations when the manager ID is on a different column and this seems to be a new scenario. I have tried a couple of methods and so far have not been successful. Any kind of help here would be much appreciated. 

[amitchandak]

@syasmin25 , refer

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

Other

Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

[syasmin25]

Hello, 

Thank you for the links. I understand how its done on the links provided. However, I am having difficulty creating paths since I only have a column that states the level the person is on. I do not have a column that has the superior ID. How would I be calculating the pathways then?