Forum Discussion

Fabi's avatar
Fabi
Frequent Visitor
2 years ago

RLS with 4 levels

Hello,

 

We have an rls that currently works : a user connects to the internet portal with his "id_adh" and he can only see his associated tickets.

 

But now we want to set up two connection parameters :

- id_adh and 200 to see the id_adh level

- id_adh and 300 to see the city level

- id_adh and 400 to see the country level

- id_adh and 500 to drink the international level (equivalent to no RLS at all)

 

Example:

- I connect with "A2" and "200", I can only see the data associated with "A2"

- I connect with "A2" and "300", I can see all the "id_adh" data of "Manchester".

- I connect with "A2" and "400", I can see all the data of "United Kingdom"

- I connect with "A2" and "500", I can see all the data in the world (equal to no rls)

 

How can I modify my data model and/or configure my rls so that this works? 

 

In advance, thank you very much for your help.

 

Here is the data used for this example :

 

 

1 Reply

  • Change your table filter DAX expressions acordingly. They need to evaluate to True() for each of your scenarios.