Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Nikit18
Frequent Visitor

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

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 IDVolume 
A12 
A24 
A26 

A3

8 

A1

9 

 

Table B

Route IDVolume
A111
A210
A38

 

 

Can someone suggest a solution. 

Thanks in advance.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you @amitchandak : This solution worked well. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.