Syntax error on all measures #480
-
|
Every measure I write in Dax Studio it shows a syntax error - even if in Power BI the measure works perfectly. As an example, the measure: POD Vacant = I get this error: Am I doing something wrong or is this a bug? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
This is not a bug. DAX Studio executes DAX queries and the syntax you have there is not a valid dax query. One possible query syntax for executing a measure like in your example and returning a single value would be something like the following: DEFINE MEASURE |
Beta Was this translation helpful? Give feedback.

This is not a bug. DAX Studio executes DAX queries and the syntax you have there is not a valid dax query.
One possible query syntax for executing a measure like in your example and returning a single value would be something like the following:
DEFINE MEASURE
qry_Employees[POD Vacant] =
CALCULATE (
[VacCnt],
FILTER(qry_Employees, [Division_Name] = "Plant Operations Division")
)
EVALUATE
{ [POD Vacant] }