Issue with RLS

[Anonymous]

Hi Guys,

I've created 2 roles for my model. As seen below

[CompanyId]=
CALCULATE (
MAX ( Users[CompanyId] ),
FILTER ( Users, Users[Email] = USERPRINCIPALNAME() )
)

[Email] = USERPRINCIPALNAME()

But below is the output I'm getting which is wrong. I'm getting 3 rows istead of 1. 

So my imp question is, when we select 2 roles simultaneously does it work as AND condition or it works as OR condition in Power BI. As far as I can see it is working as OR condition which should not be the case ideally. If I'm giving an email ID then I should be the data for only that ID.

Desired Output with both the roles:

Can anyone please help me with this???

Regards,

Himanshu

[Anonymous]

Hi @Anonymous ,

As the official document said, Multiple role mappings can result in unexpected outcomes.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[mwegener · Accepted solution]

Hi @Anonymous ,

the permissions are combined and the highest rights take effect.