Forum Discussion
SWITCH statement not working as intended
i found the issue, as i am selecting the slicer I.e. Vietnam,Indonesia, Thailand. i want to display the sum from SEA region instead but as it is filtered for Vietnam,Indonesia, Thailand it shows as blank() instead. i am now going to try and see if can do it if i change my data source to another table
Hi rgoo, I'd suggest to debug in the following way:
- "DisplaySEAData" measure: replace "CALCULATE(SUM('EVR 2014-2024'[EVR]),'EVR 2014-2024'[office_name] = "SEA")" with a static value, for instance 1 (or text "1" in your case as your else parameter "test" is a string value). In this way you can verify whether switch works as expected.
- If switch works and you get value 1, then the problem is with Calcualte(). Make sure that you apply exactly same filters when testing it alone as when "DisplaySEAData".
- If not, so with "1" switch still provides you Blank(), then rewrite your formula with variable (I'm not sure if switch is evaluating a measure when used as a "value" argument
DisplaySEAData =
VAR _SEA_Selected = [SEA Selected]
RETURN
SWITCH(
TRUE(),
_SEA_Selected,CALCULATE(SUM('EVR 2014-2024'[EVR]),'EVR 2014-2024'[office_name] = "SEA"),
"Test"
)
I hope something from it will help you! Good luck 🙂
i found the issue, as i am selecting the slicer I.e. Vietnam,Indonesia, Thailand. i want to display the sum from SEA region instead but as it is filtered for Vietnam,Indonesia, Thailand it shows as blank() instead. i am now going to try and see if can do it if i change my data source to another table
Great! Remember to acceprt the relevant asnwer as a solution when you finish, so others can find an answer to similar problem 🙂