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 ,

How about creating relationships between the tables?

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 

 

I have changed the relationships as you mentioned unfortunately it's not working. 

Complete dataset is visible to the users.

 

Please find below snapshots.

 

Could you please look provide the solution

 

Thanks in advance.