topic SWITCH with multiple conditions in DAX Commands and Tips

SWITCH with multiple conditions

aherabit — Thu, 11 Jan 2024 20:50:46 GMT

Hi Folks,

Could you help in troubleshooting this command?
The error is:
A single value for column 'Issue Type' in table 'Table one' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

measure_type_color =
SWITCH(
'Table one'[Issue Type],
"Change Request", "#3C4E4B",
"Defect", "#466964",
"Issue", "#333333",
"Requirement", "#0D6ABF",
"Story", "#E27C7C",
"#503F3F"
)

Re: SWITCH with multiple conditions

Dangar332 — Thu, 11 Jan 2024 21:00:26 GMT

Hi, aherabit

Wrap your issue type in min() or max()

measure_type_color =

SWITCH(

Min('Table one'[Issue Type]),

"Change Request", "#3C4E4B",

"Defect", "#466964",

"Issue", "#333333",

"Requirement", "#0D6ABF",

"Story", "#E27C7C",

"#503F3F"

)

Re: SWITCH with multiple conditions

aherabit — Fri, 12 Jan 2024 19:33:34 GMT

thank you!

It worked with Min().