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.
Okay, here my tables like;
ID KONU 909 IFOS (DFİF) Hakediş İşl.***2007/2** 400 Dış Krediler 730 Teslim Tutanakları 331 Teslim Tutanakları This is my system table, in Konu (Topic in English) colmn is completly true.
ID KONUSU 909 IFOS (DFİF) Hakediş İşl.***2007/2** 400 Dış Kredi 730 Teslim Tutanak 331 Teslim Tutanaklar And this is my OCR'ed table. As you see, there is some mistakes. For example in sytsem table, 730 and 331 ID's Konu is "Teslim Tutanakları" but in OCR table they are mistake. ("Teslim Tutanak" and "Teslim Tutanaklar")
So, as you see there is different ID but same Konu names in my tables and i have to compare these two table in Power BI. True table is first table, second one is OCR'ed. I expect this;
ID KONU (System Table) KONUSU (OCR'ed Table) Status 909 IFOS (DFİF) Hakediş İşl.***2007/2** IFOS (DFİF) Hakediş İşl.***2007/2** TRUE 400 Dış Krediler Dış Kredi FALSE 730 Teslim Tutanakları Teslim Tutanak FALSE 331 Teslim Tutanakları Teslim Tutanaklar FALSE Getting for this table i have tried these methods;
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() )After this compare, i will take another actions like reporting or emailing.