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?
Go to 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.⚡
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
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!