DAX if statement

[pickslides]

I'm a new Power BI user and used to SQL and excel. 

I tried this in DAX as a nested if statement, but gave me an error.

StandardResult = if(Standards[Score]>Standards[Year Level],"Above",if(Standards[Score]<Standards[Year Level],"Below","At Standard"))

Thanks for any help,

Q

[johnt75 · Accepted solution]

The code you wrote should work in a calculated column on the Standards table, but if you are creating a measure then you would need to use SELECTEDVALUE, like

StandardResult =
IF (
    SELECTEDVALUE ( Standards[Score] ) > SELECTEDVALUE ( Standards[Year Level] ),
    "Above",
    IF (
        SELECTEDVALUE ( Standards[Score] ) < SELECTEDVALUE ( Standards[Year Level] ),
        "Below",
        "At Standard"
    )
)