The result doesn't work out when using "VAR" in function

[Anonymous]

Hi all,

I'm stuck with my DAX as pics below, please help to point out the reason behind. Thank you!!

The main questions I have here are:

1. Why the "SWITCH" function doesn't work in this case?
2. Why does group work in pic 1 but pic 2? Do I always have to put all the possible filters when using "VAR" to define the algorithm?   

Please share with me if there are other mistakes I have in the pictures, thank you.

↓Expected result but with complicated, messy function.

Pic 1

↓Tried to use "var" to make the function easier to read but failed...

Pic 2

[amitchandak · Accepted solution]

@Anonymous , I think the first argument is missing

example

Switch([column],

"Value1", "Result1"

)

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56