Switch True

[gauravnarchal]

Hello - Instead of IN I want to add the condition contains in my measure. What condition can I use to make this work?

RETURN SWITCH ( TRUE(),

__PO IN { "MMS-NYC" } && __Reason = "MMS", "Missing"

[Shahfaisal]

You can use FIND function - https://learn.microsoft.com/en-us/dax/find-function-dax

Note -  FIND is case-sensitive. You can use SEARCH if you are looking for case-insensitive scenario - https://learn.microsoft.com/en-us/dax/search-function-dax

[AlexisOlson · Accepted solution]

I prefer CONTAINSSTRING in this situation since we don't care about the position of the substring.

To check if the variable __PO contains the string "MMS-NYC", you can write

CONTAINSSTRING ( __PO, "MMS-NYC" )