Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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. ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |