Call Sum of values in column X from Table A to Table B where both the tables are in Many:1 relation

[Nikit18]

Hello Everyone, 

I need to add a column in Table B where it should have sum of vlaues in Column X of Table A. 

Table A and B are in relation of Many:1 

Example 

Table A

Route ID	Volume
A1	2
A2	4
A2	6
A3	8
A1	9

Table B

Route ID	Volume
A1	11
A2	10
A3	8

Can someone suggest a solution. 

Thanks in advance.

[amitchandak · Accepted solution]

@Nikit18 , A new column in table B

Sumx(Relatedtable(TableA), TableA[Column])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Nikit18]

Thank you @amitchandak : This solution worked well.