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 ref...
  • 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"

    )

aherabit's avatar
aherabit
Helper I
2 years ago

thank you!

It worked with Min().