SWITCH

[Ning_pbi]

I tried to use SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>]) to fulfill the following logic, but failed.

case

when <expression> = <value1> then <result1>

when <expression> = <value2> then <result2>

....

else <expression>

[Ning_pbi]

problem solved.  the dax works, I noticed that I did not clear the filters. 

Thank you.