Forum Discussion
SWITCH default value not working
Hi everyone,
I’ve been using SWITCH for my report but my issue is that its default value was not showing at all and I always have to keep at least one filter on.
Variance View = SWITCH(TRUE(),
VALUES(‘Table1’[Var]) = “Enabled”, [YOY VAR],
VALUES(‘Table1’[Var]) = “Disabled”, [TOTAL],
[TOTAL]))
Attached is the matrix when the variance view is disabled. When I clear the filter, I expect it to still show [TOTAL], but the data disappears and there’s only a message saying ‘Can’t display the visual.’ Could anyone point out what did I do wrong?
Hi TP129
You are using VALUES, so when you do not select the slicer to filter Var, it returns error, you can do it like this
Variance View = VAR CurVar = SELECTEDVALUE('Table1'[Var],“Disabled”) RETURN SWITCH(TRUE(), CurVar=“Enabled”, [YOY VAR],[TOTAL])
2 Replies
Hi TP129
You are using VALUES, so when you do not select the slicer to filter Var, it returns error, you can do it like this
Variance View = VAR CurVar = SELECTEDVALUE('Table1'[Var],“Disabled”) RETURN SWITCH(TRUE(), CurVar=“Enabled”, [YOY VAR],[TOTAL])Oh I see what's the problem here. It works now, thank you very much!
