Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |