SWITCH Evaluates an expression against a list of values and returns one of multiple possible result expressions.
SWITCH(expression, value, result[, value, result]…[, else])
Expression – Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).
Value – A constant value to be matched with the results of expression.
Result – Any scalar expression to be evaluated if the results of expression match the corresponding value.
Else – Any scalar expression to be evaluated if the result of expression doesn’t match any of the value arguments.
A scalar value coming from one of the result expressions, if there was a match with value, or from the else expression, if there was no match with any value.