The Syntax for... is incorrect

Question

I cannot for the life of me determine what is wrong with this statement.&nbsp; Any help appreciated

valtterin · Answer

Hi,var needs return in the end and then you can refer to the variable.&nbsp;E.g. measure = var _a = 1return&nbsp;_aSo add: "return" and "data" and you are goodI hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

maybrick1046 · Answer

Not working with the return

valtterin · Answer

Hi, At a quick glance it seems you are missing closing ')' from your data variable.

maybrick1046 · Answer

There are many variables, and if you notice, in the data table itself it's not finding the field name.&nbsp; Can&nbsp; I hire you to help me get this right?

valtterin · Answer

Hi,The reference is greyd out if the rest of the table syntax is not working. E.g. Here I tested some similar syntax in my machine:

Measure 29 = var data = 
FILTER(
SELECTCOLUMNS(ALLSELECTED('Table (15)'[Column1]),"x",'Table (15)'[Column1],"y",1),

&nbsp; &nbsp; NOT(ISBLANK([x])) &amp;&amp; NOT(ISBLANK([y]))
&nbsp; &nbsp; )

var x_sum = SUMX(data,[x])
var x2 = SUMX(data,[x]^2)
var xy= SUMX(data,[x])
var row_count = COUNTROWS(data)

return 1This works without errors:
&nbsp;

Forum Discussion

The Syntax for... is incorrect

5 Replies

Related content

Power BI - The syntax for ')' is incorrect

The syntax for ')' is incorrect

Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'.

The syntax for 'Level' is incorrect.

The syntax for 'RETURN' is incorrect