Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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?
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. ?
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |