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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.