Forum Discussion
RLS filter combination DAX USERPRINCIPALNAME and Data filter
When creating a role to define filters, would it be possible to use filters that combine both the DAX expression "USERPRINCIPALNAME()" and another filter?
Example: Two fields in the same table: Manager / Segment
[Manager] = USERPRINCIPALNAME()
[League] = "Field Sales"
Yes this is possible
Just use [Manager] = USERPRINCIPALNAME() && [League] = "Field Sales"
4 Replies
The idea is create a Rol (Eg Mgr and Segment) that uses both filters
Yes this is possible
Just use [Manager] = USERPRINCIPALNAME() && [League] = "Field Sales"
I have created the role applying these filters, is it correct?
[League] = "Field Sales" || [Manager] = USERPRINCIPALNAME()If you need both condition to be true then use [Manager] = USERPRINCIPALNAME() && [League] = "Field Sales"
Or if you want any condition to be true then can use above
