Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
Solved! Go to 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")
perfect! that totally worked. I don't know why i didn't see that before.
@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")
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |