Forum Discussion
How to create dynamic path for role level security.
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 c...
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.
Regards,
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Proud to be a Super User!
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.
Anonymous Can you share your pbix file?
Do you really require Level 1 in the visual?
nandukrishnavs Yes require the level because needs to create matrix in the dashboard.