Forum Discussion

Maybrick1046's avatar
Maybrick1046
Frequent Visitor
3 years ago

The Syntax for... is incorrect

I cannot for the life of me determine what is wrong with this statement.  Any help appreciated
ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

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

Maybrick1046's avatar
Maybrick1046
Frequent Visitor
3 years ago

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?

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    3 years ago

    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: