Measure = single value cannot be determined

[Anonymous]

Hello, any idea why in single row with one number this issue constantly appear? See picture

[Burk]

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.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Burk]

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. 

[Ashish_Mathur]

Share both tables and show the expected result.

[Burk]

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. 

[Ashish_Mathur]

Hi,

Try these calculated column formulas in (not measure) the first table

Konusu 1 = lookupvalue(PDFOCR[KONUSU],PDFOCR[ID],AYS[ID])

Check = AYS[Konusu]=AYS[Konusu1]

Hope this helps.

[Burk]

Hi, 

I tried your advice. Here, what i got error.

The syntax for 'Check' is incorrect. (DAX(lookupvalue(PDFOCR[KONUSU],PDFOCR[ID],AYS[ID])Check = AYS[Konusu]=AYS[Konusu1])).

By the way, in AYS table, colmn name is KONU, is that a problem?

Edit: Also KONU did not worked,

The syntax for 'Check' is incorrect. (DAX(lookupvalue(PDFOCR[KONUSU],PDFOCR[ID],AYS[ID])Check = AYS[KONU]=AYS[Konusu1])).

[Ashish_Mathur]

What are DAX and check in your formula?

[Burk]

Hi, 

I am not sure "What are DAX" exactly. Do you want to me control of columns name?

If it is i renamed column names and now all topic colmn has same name "KONU".

So, i editted your code like this;

Konusu1 = lookupvalue(PDFOCR[KONU],PDFOCR[ID],AYS[ID]) 
Check = AYS[KONU]=AYS[Konusu1]

And this is the error.

[Burk]

Hi again,

I tried your formula with two colmns. First attempt i tried it in one colmn so it did not worked.

So two colmns Konusu1 and check method solved my problem.  But i got filter error. Please look that screen capture.

Thanks a lot!

Edit: There is an filter error i see. In this compare table there is just 21 false record but filter options show grater values in my tables. (203 is my total value in this list.)  

[Burk]

Is there any solution about wrong counting problem?

[Anonymous]

Hi, I'm also experiencing the same error:

IF(CONTAINSSTRING( [Manager], Employee[Name] ), true, false)

Anyone has any idea? Many thanks before!

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.

[rhemanth]

I'm calculating measure sales/sum(sales) in DAX and getting the 'single value cannot be determined' error.

Sales % of Total = CALCULATE(DIVIDE('table_name'[Sales],SUM('table_name'[Sales]))

Can anyone help me out in solving this?

Thanks

[Ashish_Mathur]

Hi,

Your question is not clear.  Describe your data, show a sample and share the expected result.

[rhemanth]

We have sales column where I want to calculate percentage of sales with the total sales.
So calculation goes like this: sales/total(sales) * 100

[Ashish_Mathur]

Hi,

The solution will depend upon what you drag to the row labels section of your visual.

[rkamiya]

Hi there,

I am having the same error, but mines about the DIVIDE. Kindly please refer on the formula below.

Which I had used, Any idea for a fix?

CH_Iteration = DIVIDE('CaseIterations_CH3PH'[CHold_Count], 'CaseIterations_CH3PH'[CHold Validate], 0)

Note that I used the above formula on creating a New Measure. 

[Ashish_Mathur]

Hi,

Try this measure

=DIVIDE(SUM('CaseIterations_CH3PH'[CHold_Count]),SUM('CaseIterations_CH3PH'[CHold Validate]),0)

Hope this helps.

[rkamiya]

thank you so much man! you nailed it right on the spot!! thank you sooooooo much in a million times!!