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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Optimusprime_25 ,

I have created a simple sample, please refer to it to see if it helps you.

 

Then create relationships between the tables.

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Optimusprime_25's avatar
    Optimusprime_25
    Resolver I
    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.