RLS

[Anonymous]

Good day

I am trying to set up RLS for Territory and Business Unit for a specific user (e.g. Gauteng & Sales = 1 person and Gauteng & Marketing = 1 person)  

Is my DAX formula correct using "&" as below:

[Region] = "GT" & [BU] = "Sales"

I am getting this error message when I click on View as Roles:

Error Message:

An error was encountered during the evaluation of the row level security expression defined on table 'ProcurementSpent'. Error message: DAX comparison operations do not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Stack Trace:

Invocation Stack Trace:

Activity ID
05951bd3-d135-e3f9-a9dd-03a6ac1f12f9

Time
Thu Nov 10 2016 13:12:09 GMT+0200 (South Africa Standard Time)

Version
2.37.4464.321 (PBIDesktop)

Error Code
rsDataShapeProcessingError

OData Error Message
Failed to execute the query.

It would work with just one DAX formula:

[Region] = "GT"

Thanks.

[Anonymous · Accepted solution]

&& not &. The AND comparison operator is &&.