topic Re: Create 2 RLS groups with different conditions in DAX Commands and Tips

Create 2 RLS groups with different conditions

Anonymous — Thu, 06 Mar 2025 14:04:32 GMT

Hi.
there aree 2 tables - Sales & Manager, (from source i am getting sales table - Email column (with 2 or 3 Emails as a single row as per screenshot, Manager table have Email column as below)

when manager logis in he should see entire report data without any filters
when sales team member login they should see only their data with RLS. How i can implement 2 RLS roles(RLS , Non RLS )by uisng 2 tables ? Any help

Re: Create 2 RLS groups with different conditions

Deku — Thu, 06 Mar 2025 15:24:43 GMT

Should the manager see all data, or data for their team?

Re: Create 2 RLS groups with different conditions

Anonymous — Thu, 06 Mar 2025 16:12:55 GMT

Deku manager should see full report (manager data + Sales team data also = Entire report he should see )

Re: Create 2 RLS groups with different conditions

Deku — Thu, 06 Mar 2025 18:41:04 GMT

Update the sales teams so single person per row. Add the sales tean table to the model and setup relationship using email.

Add managers with no relationships

Add this to a RLS role on the sales table.

Switch(

True

, USERPRINCPALNAME() in managers(), true,

, USERPRINCPALNAME() = SalesTeam[email]

)

Re: Create 2 RLS groups with different conditions

Anonymous — Fri, 07 Mar 2025 03:42:46 GMT

Deku DAX is giving Syntax for List is incorrect error, when i applied RLS on Sales Table
Could you please help

Re: Create 2 RLS groups with different conditions

Anonymous — Fri, 25 Apr 2025 12:45:36 GMT

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community Forum.

Deku Thank you for your quick response.

Anonymous Please try the below DAX in the RLS role on the Sales table:

SWITCH(
    TRUE(),
    USERPRINCIPALNAME() IN VALUES(Manager[Manager]), TRUE(),
    USERPRINCIPALNAME() = Sales[UserEmail]
)

If your problem has been solved already, please mark the helpful reply and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .

Thank you very much for your kind cooperation!

Regards,

B Manikanteswara Reddy

Re: Create 2 RLS groups with different conditions

Anonymous — Wed, 30 Apr 2025 07:54:45 GMT

Hi Anonymous ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

Re: Create 2 RLS groups with different conditions

Anonymous — Mon, 05 May 2025 06:14:25 GMT

Hi @VGL321 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

Re: Create 2 RLS groups with different conditions

Anonymous — Thu, 08 May 2025 11:52:29 GMT

Hi @VGL321 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy