A single value for column xxxx in table 'yyy' cannot be determined.

[swarren]

A single value for column 'wv_middledonormove' in table 'crmPhone' 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.

When using a switch command:

Middle Donor Moves Phone =

SWITCH (

crmPhone[wv_middledonormove],

772490000, "Invite",

772490003, "Cultivate",

772490004, "Acknowledge",

772490005, "Service",

"None")

[swarren]

perfect! that totally worked. I don't know why i didn't see that before.

[amitchandak · Accepted solution]

@swarren , This can work as new column , not measure

Middle Donor Moves Phone =
SWITCH ( crmPhone[wv_middledonormove],
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")

a new measure

Middle Donor Moves Phone =
SWITCH (
max(crmPhone[wv_middledonormove] ) ,
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")