Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI - Using DAX, how can I check which Role (from Row Level Security) the user is using?

Hi, I have created four Roles (Full Company, North, South East, and South West) via Row Level Security. The way this RLS will be implemented is by assinging the user email address (userprincipalname...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi judspud - thanks for your response but I have it all sorted now.
    I was overthinking it. I simply used the SELECTEDVALUE function on the table that the Role (RLS) was applied against.

     

     

judspud's avatar
judspud
Icon for Solution Supplier rankSolution Supplier
7 years ago

Hi Anonymous 

 

How are you implementing the RLS? i.e. which table/field are you using to filter the data?

 

Also, can a user be part of multiple roles?

 

Thanks,

George

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi judspud - thanks for your response but I have it all sorted now.
I was overthinking it. I simply used the SELECTEDVALUE function on the table that the Role (RLS) was applied against.