Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Local punctuation doesn't work in role assignment condition.

When adding a role to a condition: IF (1 = 5; MAX ('SalesRep' [UserName]) = Username (); 1 = 1) an error about incorrect syntax appears. If you write: IF (1 = 5, MAX ('SalesRep' [UserName]) = Use...

Data Modeling

v-yuta-msft
6 years ago
Anonymous ,

There's a little bit difference between the dax expression in role definition and measure/calculate column.

Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipalname-dax-function

Regards,

Jimmy Tao

v-yuta-msft

Community Support

6 years ago

Anonymous ,

There's a little bit difference between the dax expression in role definition and measure/calculate column.

Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipalname-dax-function

Regards,

Jimmy Tao

Forum Discussion

Local punctuation doesn't work in role assignment condition.

Related content

Assigning Values based on conditions

Priority Based Sales Rep Assignment

Rank with conditions

Assign (Transfer) Ownership

Text, return a list of punctuation in correct positons