Counting a one to many relationship

[Welsh_Will]

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 ID	Quotes
001	ABCD
001	EFGH
001	IJKL
002	MNOP
002	QRST
002	UVWX
002	YZAA
003	ABAC

Shipment ID	Number of Quotes
001	3
002	4
003	1

[parry2k · Accepted solution]

@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.⚡