Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello, any idea why in single row with one number this issue constantly appear? See picture
Solved! Go to Solution.
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.
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.
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?
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.
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.)
Is there any solution about wrong counting problem?
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.
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.
Hi,
The solution will depend upon what you drag to the row labels section of your visual.
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.
thank you so much man! you nailed it right on the spot!! thank you sooooooo much in a million times!!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
92 | |
92 | |
84 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |