lookup value from another table

[snifer]

Hi i got 2 table

table 1 'RECO GL DK SALE			table 2 RECO EAST DK SALE
Document No.	Amount			Document No.	Amount	lookup from table 1 (this is what i want)
100	150			100	300	270
100	120			1001	50	50
1001	50

I wanna to do this

AMOUNT GL look reco = LOOKUPVALUE('RECO GL DK SALE'[Amount],'RECO GL DK SALE'[Document No.],'RECO EAST DK SALE'[Document No.])

but I got an error because in table 1 there are multiple line in tabel 1

A table of multiple values was supplied where a single value was expected.

how i can have the sum of these lines in table 1?

[PattemManohar · Accepted solution]

@snifer Please try this as a "New Column" in your table 2

LkpAmount = CALCULATE(SUM(Test124Lkp[Amount]),FILTER(Test124Lkp,Test124Data[DocumentNo]=Test124Lkp[DocumentNo]))