Power BI - Syntax Error for all VAR in all .pbix files

[zhxj]

When I tried to create a new VAR in a new measure, the DAX prompt a sytax error "The syntax for ')' is incorrect (DAX(VAR))."

The problems:

1. there is no ')' after the VAR.

2. the error occurs for any VAR I created, even in a seperate .pbix file.

3. It used to be fine, but when I saved a file with DAX equations not finished, then all the .pbix files are affected.

It seems that the parser error in one measure spread to all the .pbix files.

Does anyone solved such issue before?

  syntax error

[danextian · Accepted solution]

Hi @zhxj ,

Is that the whole of your measure? If so that is incomplete. The syntax of a measure/calc column or table with variables should be something like

Name =
VAR VariableName1 = <expression>
VAR VariableName2 = <expression>
RETURN
VariableName or Expression