Need Help on DAX - SWITH / IF Function results incorrect

[Rajamanikandan]

Comparing two measures [Ref CY], [Ref PY] and deriving a custom tag for each record.

The calculation below works well for some scenarios but incorrectly calculates if it meets "ELSE" condition records. Any suggestion would be much appreciated.

Priority =

    IF

    (   AND

        ( [Ref CY]=0,[Ref PY]=0),"C",

        IF

        ( AND ([Ref CY]=0,[Ref PY]>=1),"b",

        "B")

    )

Priority Alt =

SWITCH

(

    TRUE,           

    (([Ref CY]=0) && ([Ref PY]=0)), "C",

    (([Ref CY]=0) && ([Ref PY]>=1)), "b",   

    "B"

)

The calculation works well

But it is incorrect if any record meets on ELSE condition

[lbendlin · Accepted solution]

Power BI is not case sensitive. "B" and "b" will be grouped together in the UI.

[Rajamanikandan]

Thank you. You saved me. It works.

I need to research how it's grouped together and learn more. Added space to achieve the result.

 "DAX is simple but not easy"