Wrong value returned

The DAX statement is working perfectly fine. I have attached the sample below.

Hi Blaired79 

For your question, here is the approach I provide:

Here's some dummy data

"Table"

If you are creating a calculated column, your code will work.

Column Rating2 = 
    SWITCH(
        TRUE(), 
        [Total Score] < 6, "No change", 
        [Total Score] >= 6 && [Total Score] < 10, "Low", 
        [Total Score] >= 11 && [Total Score] < 15, "Medium", 
        [Total Score] >= 16 && [Total Score] < 20, "Low", 
        ""
    )

So I'm assuming if you create a measure.

Create a measure. Try the following code:

Measure Rating2 = var _score =  SELECTEDVALUE('Table'[Total Score])
RETURN  SWITCH(
        TRUE(), 
        _score < 6, "No change",
        _score >= 6 && _score < 10, "Low", 
        _score >= 11 && _score < 15, "Medium", 
        _score >= 16 && _score < 20, "Low", 
        " "
    )

Here is the result.

If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.