Forum Discussion
Measure = single value cannot be determined
Hi There,
You should understand the difference between the Measure and Calculated Column. The Calculation you are trying to achieve is more suitable for calculated column and that's why showing an error for the measure calculation.
For measure, You should try SUMX.
measure:=SUMX(list,list[TURNOVER]*5)
Thanks & Regards,
Bhavesh
Hi everyone,
I have got two tables contents ID and other text columns which named KONU and KONUSU. I releated with ID colums between two tables. ( Many to one and Both Cross Filter Direction)
So i have to compare these two string value columns and by last result i will be get a new column true or false. It's classic and simple as hell as EXACT function in excel but i can not get result any methods of DAX functions in this table. Here what i tried.
EXACT= IF (AYS[KONU] = PDFOCR[KONUSU], "SAME", "Not Same")I got this error message in for this code. Same error for this method too, link.
A single value for column 'KONU' in table 'AYS' 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.Also i have tried measure method. But these colmns Types are Text so measure giving no error or result.
COMPARE = IF ('MEASURES'[AYS Konu] = 'MEASURES'[PDFOCR KONUSU], TRUE(), FALSE() )In conclusion, how can i compare and get exact result in Power BI?
Thx a lot,
Burk.
Hi,
Share some data and show the expected result.
Hi, Ashish
My tables looks like it. There is two table like it. One of table OCR table and the other is got by system. I have to compare them.
Share both tables and show the expected result.
