topic Re: Apply RLS on horizontal level in DAX Commands and Tips

Apply RLS on horizontal level

Anonymous — Thu, 25 May 2023 13:15:02 GMT

Hello everyone,

Here is an example of data i am working with :

Fact table

Managers table

And here is the role that i've created for test :

I am working on a business need who requires that a manager could see the global amount of his collegues but not the details.

Initial report looks like that :

Below the result when i apply my role :

But what i really need is this :

A picture is worth a thousand words : the manager (M1) have to access only the data of his station (G11) or the global amounts of his hierarchy.

Do you have any idea how could i achieve this ? I would greatly appreciate any insights or help.

Kind regards,

lbendlin — Sat, 27 May 2023 02:51:28 GMT

I don't think you can use static RLS for that. Consider using dynamic RLS.

Anonymous — Wed, 31 May 2023 09:48:43 GMT

Any idea how to do this with dynamic RLS ?

lbendlin — Wed, 31 May 2023 10:40:38 GMT

It's as simple as maintaining a permissions mapping table that you control via USERPRINCIPALNAME.