topic Re: A single value for column xxxx in table 'yyy' cannot be determined. in DAX Commands and Tips

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

swarren — Thu, 28 Apr 2022 20:21:18 GMT

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

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

amitchandak — Fri, 29 Apr 2022 01:36:56 GMT

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

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

swarren — Fri, 29 Apr 2022 14:52:31 GMT

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