I have a requirement where i have to create role level security as per organization structure. I tried doing this using PATH function. However, got stuck in below scenario:
In case when Amy login he should only see the data for himself and Lindsay, But in my current development I am getting below output.
It should not show Reza Rad.
I am gusseing this is happening because in the PATH column, it generated 1|5|8, How can I create such path which is dynamic. i.e.
if Amy logs in he should get data only for those which are below not for above one.
Try the below logic in the RLS.
VAR _email = USERPRINCIPALNAME() VAR _id = CALCULATE(SELECTEDVALUE('Table'[ID] ),FILTER('Table',[Email]=_email)) VAR _resultFilter = PATHCONTAINS([Path],_id) return _resultFilter
Please find the attached pbix file.
@nandukrishnavs Thanks for you response. However, the solution which you provided is the same which I already have. My issue is If Amy logs in Reza Rad should not appear.
@nisha Can you generalize the logic? Why can't you use Level 2 and Level 3? Then you will not see "Reza Rad" right? Suppose if Reza Rad login what should be the results? If you could provide more examples, we can try.
Looks like I dont have permission to attached pbix file. However, my requirement is, I have to create a matrix which will have all the levels. For example. In my case I have 3 level. Now issue is whenever Reza and Leila login they will see correct data. However, when Others logins, they will get Level 1 value as well. For example: If Bill login he will see Leila and Mark as well. I dont want to show higher level data. It should filter out.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!