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

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.

Hello Anonymous ,

Thanks for your prompt response.

I am unable to send the sample pbix file here.

I will attach the snapshots of tables below.

This is the user details table, here we cans ee that which user has which access. User should see only data for which he has access (Ex: specific country and specific unit)

Below is the country table

Below is the unit table

Below is the main table in which the data should be restricted for a particular user.

This is teh complete dataset, in which each particular user should see only that data which the user has been provided with the access in user details table.

Main agenda of this task is to restrict the data according to the country and unit as well for any particular user.

Thanks in advance.