title: Power BI - totals per related entity
body: <p>Basically, I’d like to get one entity totals, but calculated for another (but still related/associated!) entity.  Relation type between these entities is many-to-many.
  Just to be less abstract, let’s take Trips and Shipments as mentioned entities and Shipments’ weight as a total to be calculated.
  Calculating weight totals just per each trip is pretty easy task. Here is a table of Shipments weights:
  <a href="https://i.stack.imgur.com/4vShR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4vShR.png" alt="shipments with their weights"></a></p>
  
  <p>We place them into some amounts of trucks/trips and get following weight totals per trip:
  <a href="https://i.stack.imgur.com/dmHRx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dmHRx.png" alt="Shipments&#39; weight total per trips"></a></p>
  
  <p>But when I try to show SUM of Trip weight totals (figures from 2nd table) per each related Shipment (Column from 1st table), it becomes much harder than I expect.
  It should look like:
  <a href="https://i.stack.imgur.com/BrM1O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BrM1O.png" alt="needed table I can&#39;t get in Power BI"></a></p>
  
  <p>And I can’t get such table within Power BI.</p>
  
  <p>Data model for your reference:
  <a href="https://i.stack.imgur.com/NDIjA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NDIjA.png" alt="data model"></a></p>
  
  <p>Seems like SUMMARIZE function is almost fit, but it doesn’t allow me to use a column from another table than initialized in the function:
  <a href="https://i.stack.imgur.com/XpJ7y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XpJ7y.png" alt="almost fit but not"></a></p>
  
  <p>Additional restrictions:</p>
  
  <p>Selections made by user (clicks on cells etc.) should not affect calculation anyhow.</p>
  
  <p>The figures should be able to be used in further calculations, using them as a basis.</p>
  
  <p>Can anyone advise a solution? Or at least proper DAX references to consider? I thought I could find a quick answer in DAX reference guide on my own. However I failed to find a quick answer.</p>