Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
&& not &. The AND comparison operator is &&.
Proud to be a Super User!
&& not &. The AND comparison operator is &&.
Proud to be a Super User!
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |