Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Measure = single value cannot be determined

Hello, any idea why in single row with one number this issue constantly appear? See picture
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Okay, here my tables like;

 

IDKONU
909IFOS (DFİF) Hakediş İşl.***2007/2**
400Dış Krediler 
730Teslim Tutanakları
331Teslim Tutanakları

This is my system table, in Konu (Topic in English) colmn is completly true. 

 

IDKONUSU
909IFOS (DFİF) Hakediş İşl.***2007/2**
400Dış Kredi
730Teslim Tutanak
331Teslim 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;

 

IDKONU (System Table)KONUSU (OCR'ed Table)Status 
909IFOS (DFİF) Hakediş İşl.***2007/2**IFOS (DFİF) Hakediş İşl.***2007/2**TRUE
400Dış Krediler Dış KrediFALSE
730Teslim TutanaklarıTeslim TutanakFALSE
331Teslim TutanaklarıTeslim TutanaklarFALSE

 

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's avatar
Ashish_Mathur
Super User
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Ashish_Mathur
      Super User
      4 years ago

      What are DAX and check in your formula?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.