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
Syndicate_Admin
Administrator
Administrator

ERROR "A table of multiple values was provided where a single value was expected."

Hello good day, I have a problem with the next calculated column "accounting account".
This calculated column had been running smoothly, but stopped working by throwing the following message "A table of several values was provided where a single value was expected.


Management =
IF('Supplier Flow'[Cost Center] = "No Cost Center Found",'Supplier Flow'[Accounting Account],'Supplier Flow'[Cost Center])


Accounting Account = IF(LOOKUPVALUE('Accounting Movements for Accounting Account'[Accounting Account],'Accounting Movements for Accounting Account'[Comb(Folio,NDoc)],'Supplier Flow'[Comb(Folio,NDoc)]) = "Export Materials Stock","Exports",LOOKUPVALUE('Accounting Movements for Accounting Account'[Accounting Account],'Accounting Movements for Accounting Account'[Comb(Folio,NDoc)],'Supplier Flow'[Comb(Folio,NDoc)]))

Accounting account will look for the combination to the following Table "Accounting Movements for accounting account" which does not have unique records.

wzuniga_0-1650642345688.png

I hope you can help me, since before the report worked without problems :C

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Thank you very much for the help, the problem arose since there are duplicate records with the same information. for example the following:

wzuniga_0-1650648880846.pngPerform a filter to remove duplicates by PowerQuery leaving the report functional again.

thank you very much as well!

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Thank you very much for the help, the problem arose since there are duplicate records with the same information. for example the following:

wzuniga_0-1650648880846.pngPerform a filter to remove duplicates by PowerQuery leaving the report functional again.

thank you very much as well!

amitchandak
Super User
Super User

@Syndicate_Admin , it seem like lookup is giving more than one value

 

Try like

 

Accounting Account = if( maxx(filter('Accounting Movements for Accounting Account', 'Accounting Movements for Accounting Account'[Comb(Folio,NDoc)]= 'Supplier Flow'[Comb(Folio,NDoc)] ) 'Accounting Movements for Accounting Account'[Accounting Account]) = "Export Materials Stock","Exports",
maxx(filter('Accounting Movements for Accounting Account' ,'Accounting Movements for Accounting Account'[Comb(Folio,NDoc)] = 'Supplier Flow'[Comb(Folio,NDoc)]), 'Accounting Movements for Accounting Account'[Accounting Account]))

wzuniga_1-1650646961101.png

Maybe I'm doing something wrong, but it doesn't take my face.
Could you share the report file for more help?

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.