Forum Discussion

pickslides's avatar
pickslides
Icon for Helper I rankHelper I
4 years ago
Solved

DAX if statement

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(...
  • johnt75's avatar
    johnt75
    4 years ago

    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"
    )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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