Distribution of values based on other table

[Mani_1]

Hi,

Is it possible to distibute the values based on two tables? I have two tables both are connected via Key, by one to many relationship. Now when i use the matrix then i have the result below

But i want to distibute the revenues values  of x-company into the following:

The sample data is as follows:

Table1

Table2

Thanks in advance

@parry2k @amitchandak @Greg_Deckler 

[amitchandak]

@Mani_1 ,

New column in Table 2=

var _val = sumx(filter(Table1, Table1[Key] = Table2[Key] && Table1[Compay] = Table2[Invoice Recipent]) , Table1[Revenue])

var _st = sumx(filter(Table2, Table2[Key]= earlier(Table2[Key]) && Table2[Invoice Recipent]=  earlier(Table2[Invoice Recipent])) , Table2[Invoice Amount])

return

divide([Invoice Amount], _st)*_val

[Mani_1]

Hi @amitchandak ,

The code doesn't work.