Forum Discussion

aherabit's avatar
aherabit
Helper I
2 years ago
Solved

SWITCH with multiple conditions

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"
)
  • Dangar332's avatar
    Dangar332
    2 years ago

    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"

    )

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    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"

    )