How to create dynamic path for role level security.

[Anonymous]

Hi All,

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.

Kindly help.

[nandukrishnavs]

@Anonymous 

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.

[Anonymous]

@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.

[nandukrishnavs]

@Anonymous Can you share your pbix file?

Do you really require Level 1 in the visual?

[Anonymous]

@nandukrishnavs Yes require the level because needs to create matrix in the dashboard. 

[nandukrishnavs]

@Anonymous 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.

[Anonymous]

How to attach pbix file. Unable to find the icon.

[Anonymous]

Hi,

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.