Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |