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.
Hi together,
Im trying to compare 2 columns of the same table with Dax measure EXACT in PBI:
I get this error: A single value for column 'category' in table 'new lines' 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.
Could someone help me, please?
Kind regards
Dominik
Solved! Go to Solution.
@Anonymous
If you are adding a new column with your formula, then it works, for measure, you need to add the two fields in a table visual then add the following measure
Measure = EXACT( max('new lines'[Lvl10]) , max('new lines'[category]) )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
If you are adding a new column with your formula, then it works, for measure, you need to add the two fields in a table visual then add the following measure
Measure = EXACT( max('new lines'[Lvl10]) , max('new lines'[category]) )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you Fowmy! It works!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |