Multiple roles for one user

Hi, fbackes 

If you set two rules in two roles, the result will be the data filtered by rule one as well as the data filtered by rule two. If you want to get the intersection of two rules, you need to put two rules into one role with a "&&". I created data to reproduce your scenario.

Table:

Two rules in two roles:

CompanyLevel: [Company] = "C1"
DepartmentLevel: [Department] = "A"

Two rules in one role:

Conpamy&Department: [Department] = "A" && [Company] = "C1"

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.