Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |