topic The Syntax for... is incorrect in DAX Commands and Tips

The Syntax for... is incorrect

Maybrick1046 — Wed, 18 Jan 2023 11:56:04 GMT

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

Re: The Syntax for... is incorrect

ValtteriN — Wed, 18 Jan 2023 12:01:41 GMT

Hi,

var needs return in the end and then you can refer to the variable.

E.g. measure = var _a = 1
return
_a

So add: "return" and "data" and you are good

I 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/

Re: The Syntax for... is incorrect

Maybrick1046 — Wed, 18 Jan 2023 13:05:54 GMT

Not working with the return

Re: The Syntax for... is incorrect

ValtteriN — Wed, 18 Jan 2023 13:09:05 GMT

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

Re: The Syntax for... is incorrect

Maybrick1046 — Wed, 18 Jan 2023 13:11:04 GMT

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

Re: The Syntax for... is incorrect

ValtteriN — Wed, 18 Jan 2023 13:42:14 GMT

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),

NOT(ISBLANK([x])) && NOT(ISBLANK([y]))

)

var x_sum = SUMX(data,[x])

var x2 = SUMX(data,[x]^2)

var xy= SUMX(data,[x])

var row_count = COUNTROWS(data)

return 1

This works without errors: