SWITCH default value not working

[TP129]

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?

[Anonymous · Accepted solution]

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])

[TP129]

Oh I see what's the problem here. It works now, thank you very much!