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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Help to work using 2 tables

Hey guys,

 

I'm trying something in my Power BI and i aint getting any success.

 

I'll try explain my issue:

 

I have 2 tables

 

On table A, i have the Orders and Line of these Orders

for example:

OrdersLine
123451
123452
567891
987661
432131
432132
432133

 

The value Orders + Line (123451, for example) is unique in the table.

 

Now in my table B i have the details of these orders

For exemple:

OrderLineQty
1234510
1234512
1234513
1234521
1234522
1234523
1234524
56789110

 

You can notice that values Order + Line repeat on this table

 

Now what i need is, with tha table A, get the sum of QTY from table B

For example

OrderLineQty
1234515
12345210
56789110

 

I tryied to connect both tables with relationships but i only can make a Many-To-Many relationships and when i try to sum the Qty I only get the value from 1 row and not all of them.

For example

OrderLineQty
1234512
1234521
56789110

 

So, thats what im struggling with.

I dont know if i was clear in my explantion, maybe its a relationship issue or i dont even need do a relationship and i dont know what im doing haha...

 

Please, somebody could help me? 😞

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Please check the below picture and the sample pbix file's link down below.

I think the relationship between TableA and TableB has to be something like below.

 

 Picture7.png

 

https://www.dropbox.com/s/dnsdejjh2xrrgfc/henriquemalone.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Please check the below picture and the sample pbix file's link down below.

I think the relationship between TableA and TableB has to be something like below.

 

 Picture7.png

 

https://www.dropbox.com/s/dnsdejjh2xrrgfc/henriquemalone.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.