create calculated column based on 3 tables

[mhusaein]

 

 

 

i have 3 tables as follows 

table 1 : 

table 2 : 

 

table 3 : 

i need to get the sum of table1[value] and instert it as a column in table[3] as i will make extra calculations after this

Relations are as follows:

table1[code] & table2[code] , many to one.

table2[type] & table3[type] , one to many.

id column in table1 and table 3 has duplicates 

[tamerj1]

Hi @mhusaein 

what are the cardinalities of these relationships? Which ones are active and which are in inactive?

[mhusaein]

Hi @tamerj1 , i updated table 2 , doesn't contain an id column now.

also added more details about the tables relations in the original post

[tamerj1 · Accepted solution]

@mhusaein 

Please try

CalculatedColumn =
SUMX (
FILTER (
CALCULATETABLE ( table1, CROSSFILTER ( table2[type], table3[type], BOTH ) ),
table1[id] = table3[id]
),
table1[value]
)

[mhusaein]

thanks @tamerj1  it worked perfectly