cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Welsh_Will
Helper II
Helper II

Counting a one to many relationship

Hi

 

I have a table that has Shipment ID as the primary key, and another that has Quote Number as the primary key. There are many quotes to one Shipment ID. How can I count the number of quotes per shipment in my Shipment ID table please?

 

Shipment IDQuotes
001ABCD
001EFGH
001IJKL
002MNOP
002QRST
002UVWX
002YZAA
003ABAC

 

Shipment IDNumber of Quotes
0013
0024
0031
1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Welsh_Will establish a relationship between the shipment and the shipping budget table in the shipping ID, it will be one for many relationships. add the following measure

Number of Quotes = COUNTROWS ( QuoteTable )

To display, use the visual table, use the shipment ID of the shipment table and the new measure, and you get the result.

Check out my latest blog post Year-2020, Pandemic, Power BI and beyond to get a summary of my favorite versions of Power BI features in 2020

I'd like to Compliments if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to congratulate anyone who has helped solve your problem. It's a show of thanks!

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultation.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@Welsh_Will establish a relationship between the shipment and the shipping budget table in the shipping ID, it will be one for many relationships. add the following measure

Number of Quotes = COUNTROWS ( QuoteTable )

To display, use the visual table, use the shipment ID of the shipment table and the new measure, and you get the result.

Check out my latest blog post Year-2020, Pandemic, Power BI and beyond to get a summary of my favorite versions of Power BI features in 2020

I'd like to Compliments if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to congratulate anyone who has helped solve your problem. It's a show of thanks!

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultation.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors