Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Measure = single value cannot be determined

measures.PNG

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

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

29 REPLIES 29
Burk
Frequent Visitor

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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. 

Hi,

Try these calculated column formulas in (not measurethe first table

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

Check = AYS[Konusu]=AYS[Konusu1]

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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])).

What are DAX and check in your formula?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

sq.PNG

 

 

Burk
Frequent Visitor

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.)  

 

chc.PNG

Burk
Frequent Visitor

Is there any solution about wrong counting problem?

salmayarista
New Member

Hi, I'm also experiencing the same error:

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

 

Anyone has any idea? Many thanks before!

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
rhemanth
New Member

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

 

 

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
rkamiya
New Member

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. 

 

 

Hi,

 

Try this measure

 

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

 

Hope this helps.

 

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.