Forum Discussion

Optimusprime_25's avatar
Optimusprime_25
Resolver I
3 years ago
Solved

Dynamic RLS based on multiple depts in multiple countries for a specific user

Hello Team,   I am currently stuck at implementing RLS for multiple depts in multiple countries for a specific user.   I have successfully implemented RLS, in filtering multiple countries for a p...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Optimusprime_25's avatar
    Optimusprime_25
    3 years ago

    Hi Anonymous ,

     

    Thanks for your support.

     

    I have implemnted the dynamic RLS based on multiple countries and multiple depts for a specific user.

     

    Below are the relationships which I have implemented between multiple tables.

     

    Below is the DAX which I have implemented in the roles.

    In above DAX code, we are restricting country as well as unit of a specific user.

    From above example, we can see that emp3 is having access to USA and Canada and units ABC and XYZ.

    So he is able to see the respective data

     

    Thank you.

AM_BSL's avatar
AM_BSL
Frequent Visitor
3 years ago

I have same requirement but getting the below issue

also tried this but not working 

 

Please suggest

 

Optimusprime_25's avatar
Optimusprime_25
Resolver I
3 years ago

AM_BSL 

 

Please verify the datamodel and create the relationships as it is and also please make sure you have the similar kind of columns in the tables which I have used for joining the tables.

 

In your DAX I can see there is no Related function, which is used for joining the tables. Please make sure you follow the same code and same datamodel in order to make it work.