Get values from another row

[Talal141218]

Hi Profissionals, 

I have two tables one of them Dimination Tabel and include column with account sheets number ( like customer Nr , Cash discount ), and aonther table is fact table with amounts and invoice number. 

My question is, how can i get all discounts for spicific customer?. 

please look at the screenshot. 

Please if you need more infos don't hesitate to mention. 

Thanks in advance.

[Talal141218]

Thanks for your Support, Yes we have a relation between two tables. Find the Pic below : 

[RSC]

Hi @Talal141218,
could you please tell, do we have any relationship between table?
Or any column on the bases of that you can find the values in other table if so then you use
LOOKUP

CustomerNameLookup = 
LOOKUPVALUE(
    CustomerLookup[CustomerName],
    CustomerLookup[CustomerID], Orders[CustomerID]
)

Thanks 

[Talal141218]

I want to clairyfy my question : The customers and cash discounts (LedgerAccount)-DIM Table and both have the same invoice number. The Invoice is  a column int the fact- generalledger,but the have different amount in the Fact-Generalledger. The relate i want to create is : Customer Nr. (LedgerAccount)-between 10000 till 29999 and  the invoice number and the amount, which belong to cash discount. In that's way can i get how much discount get every customer. :).