Switch(SelectedValue Help

[Anonymous]

Hello - I am trying to write a what I think is a simple dax statement however I always end up with an error. I looked at a blog which provides the same type of logic however I cannot get mine to work. Please Help, what am I doing wrong?

SWITCH(SELECTEDVALUE(SAMPLE_TABLE[PROJECT_HEALTH],"Red","Red","Green","Green",BLANK(),"Complete", ""))

Thanks for any help!

[CNENFRNL · Accepted solution]

SWITCH(
    SELECTEDVALUE( SAMPLE_TABLE[PROJECT_HEALTH] ),
    "Red", "Red",
    "Green", "Green",
    BLANK(), "Complete",
    ""
)

[Anonymous]

Thank you so much. Something so easy and I seem to still struggle.