Sum error on text function

[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. 

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?

[v-ljerr-msft · Accepted solution]

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. 

Regards

[EMauterer]

That worked.  Thank you!!

[v-ljerr-msft]

Hi @EMauterer,

Great to hear the problem got resolved! Could you accept the corresponding reply as solution to close this thread? 

Regards

[Sean]

This error indicates you are trying to create a Measure.

Try again make sure you click New Column not New Measure

[EMauterer]

I get the same error whether I set this up as a measure or a column.  ?