Sum values from two columns in another table

[PetrK]

Hi,

which formula calculate values in "calculated column" in table 1?

Tables has relationship based on column "id"

Thank you

[ryan_mayu]

@PetrK 

pls try this

Column = RELATED(Table2[A])+RELATED(Table2[B])

[PetrK]

thank you, and how to do same but with tables which have not relationship?

[ryan_mayu]

@PetrK 

you can try this

Column = sumx(FILTER(Table2,'Table1'[id]=Table2[id]),'Table2'[A])+sumx(FILTER(Table2,'Table1'[id]=Table2[id]),'Table2'[B])

[PetrK · Accepted solution]

Thank you for good idea, I used nad creted faster sollution 

column = CALCULATE( SUM(table2[A]) + SUM(table2[B]), Filter(table2, table1[id]=table2[id]))