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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Error creating a lookupvalue from a DAX table

Hello Community,

 

I am trying to lookupvalue from one table into another table both Tables were created with using Summarizecolumns  function as shown below.

And the reason I am using the Summarizecolumns is that they make my model run faster.

The data used  to mimic my scenario  is avaiable on this link -> https://community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls 

Table1

 

Table1 = SUMMARIZECOLUMNS(
                  Orders[Customer ID],
                  Orders[Category],
                  Orders[City],
                  Orders[Country],
                  Orders[Order ID],
                  "Sum of discount",sum(Orders[Discount])
            )

 

Table2

 

Segmenttable = SUMMARIZECOLUMNS(
                 Orders[Customer ID],
                 Orders[Country],
                 Orders[City],
                 "Sum of Sales",SUM(Orders[Sales])
)

 

Lookupvalue query

 

LOOKUPVALUE('Table'[Sum of discount],'Table'[Customer ID],Segmenttable[Customer ID])

 

I get this error

 

A table of mutiple values was supplied where single value was expected.

 

I humbly appreciate ideas to resolve this issue.

 

Thank you.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Try a new column like

 

sumx(filter('Table', 'Table'[Customer ID] = Segmenttable[Customer ID]), 'Table'[Sum of discount])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Try a new column like

 

sumx(filter('Table', 'Table'[Customer ID] = Segmenttable[Customer ID]), 'Table'[Sum of discount])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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