Passing values in many to many relation

[STRUSINIO]

Hey,
im facing the problem with passing values between two tables in many to many relationship (product to product).
Table1:

Table 2:

What im trying to do is to create a calculated column in Table 1 that will show Sum of sales for specific product but only once. 
Expected result:

already played with sumx function in different ways, but it always replicate my results for each of three rows in that example.
Im woundering if that expected output is even possible to create. 

Thanks in advance for any guidence 

[amitchandak · Accepted solution]

@STRUSINIO , You need first add an index column in power query

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

then add the new column in dax

New column =

var _min = minx(filter(Table1, [product] = earlier([product]) ), [Index])

var _sum = sumx(filter(Table2, Table1[product] = (Table2[product]) ), Table2[sales])

return 

if([index] =_min, _sum, blank())