Divison between two columns from different table and repetitive value.

[Anonymous]

Hi Everyone,

I need help:

I have two tables Lets say 1&2

Result i want is :

Which is like Amount= If Probill is same add Gross weight and devide it by Freight amount (250.1*90/150)

Any suggestion is highly appreciated.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Use the below dax  to create a new column:

test = LOOKUPVALUE(Table1[Reeight Amount],Table1[Pro Nmuber],'Table2'[Probill#])*'Table2'[Gross weight]/150

Best Regards

Lucien

[amitchandak]

@Anonymous , Join both of them assume it 1 -Many from first table to second

a new measure =

sumx(Table2, calculate( Divide(Table2[Gross weight]* related(Table1[ Freight amount]), sumx(filter(Table2, Table2[Prodbill#] = earlier(Table2[Prodbill#]) ), [Gross weight])) ) )