SWITCH with multiple conditions

[aherabit]

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

[aherabit]

thank you!

It worked with Min().

[Dangar332 · Accepted solution]

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"

)