Hi @jafernandezpuga Thanks for the response , the suggestion works, but when I try to pass it into a switch parameter I have this error The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
This is the way I am using it
TestTable3 =
VAR _filtera =
FILTER(
‘Hours Table’,
VAR t = ‘Hours Table’[Team]
RETURN
t = “a”
)
VAR _filterb =
FILTER(
‘Hours Table’,
VAR t = ‘Hours Table’[Team]
RETURN
t = “b”
)
VAR ST =
SWITCH(
SELECTEDVALUE(‘SelectTeams’[Teams]),
“A”,_filtera,
“B”,_filterb,
_filtera
)
VAR b = CALCULATETABLE(
SELECTCOLUMNS(
‘Hours Table’,
“Test”,‘Hours Table’[Hours]
),
ST
) return b
Thank you