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(Standards[Score]<Standards[Year Level],"Below","At Standard"))

 

Thanks for any help,

 

Q

 

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

1 Reply

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