Forum Discussion
Sum error on text function
This has to be something obvious I'm missing. I'm trying to create a new text column that pulls a text value from a different table, and populates the column with a text string if the lookup is not found in the other table.
My formula is: CustomerChannel = if(isblank('Channel'[Channel]),"Wholesale",'Channel'[Channel])
The error I am getting is:
A single value for column 'Channel' in table 'Channel' 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.
Ideas?
Hi EMauterer,
This has to be something obvious I'm missing. I'm trying to create a new text column that pulls a text value from a different table, and populates the column with a text string if the lookup is not found in the other table.
What's the relationship between the two tables? If there is a many to one(*:1) relationship between your current table you want to add the new column into and your "Channel" table, then the formula below should work in your scenario.
CustomerChannel = IF ( ISBLANK ( RELATED ( 'Channel'[Channel] ) ), "Wholesale", RELATED ( 'Channel'[Channel] ) )If that is not the case, please post your table structures with some sample data and your expected result. :smileyhappy:
Regards
5 Replies
Hi EMauterer,
This has to be something obvious I'm missing. I'm trying to create a new text column that pulls a text value from a different table, and populates the column with a text string if the lookup is not found in the other table.
What's the relationship between the two tables? If there is a many to one(*:1) relationship between your current table you want to add the new column into and your "Channel" table, then the formula below should work in your scenario.
CustomerChannel = IF ( ISBLANK ( RELATED ( 'Channel'[Channel] ) ), "Wholesale", RELATED ( 'Channel'[Channel] ) )If that is not the case, please post your table structures with some sample data and your expected result. :smileyhappy:
Regards
That worked. Thank you!!
Hi EMauterer,
Great to hear the problem got resolved! Could you accept the corresponding reply as solution to close this thread? :smileyhappy:
Regards
This error indicates you are trying to create a Measure.
Try again make sure you click New Column not New Measure
I get the same error whether I set this up as a measure or a column. ?
