Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Switch Selected Value for no selected value

So I have a working switch statement for a selected value, with two options, but I was wondering if I could get a third switch statement working for if neither option is selected.   the Slicer has ...
Need Help
  • ravsha85's avatar
    ravsha85
    2 years ago

    Hi Anonymous  could you please try this

     

    SWITCH(
    TRUE(),
    SELECTEDVALUE(Choice) = "A", SUM(X),
    SELECTEDVALUE(Choice) = "B", SUM(Y),
    TRUE(), SUM(Z)
    )

ravsha85's avatar
ravsha85
Frequent Visitor
2 years ago

Hi Anonymous  could you please try this

 

SWITCH(
TRUE(),
SELECTEDVALUE(Choice) = "A", SUM(X),
SELECTEDVALUE(Choice) = "B", SUM(Y),
TRUE(), SUM(Z)
)

juleshorton's avatar
juleshorton
Icon for Advocate III rankAdvocate III
1 year ago

This syntax works better than most I've tried, but mine doesn't switch to the last option when nothing is selected?