Forum Discussion
DAX EXACT
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
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]) )
2 Replies
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]) )