The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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"
Solved! Go to Solution.
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
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"