Forum Discussion

Olwin's avatar
Olwin
Frequent Visitor
1 year ago
Solved

Sum from another table

Hi there,   I have a table relation like below: 1. Location (Loc Code) 2. Item (Item Code) 3. Shipment Planning (Planning No, Loc Code, Item Code, Quantity) Relationship with Location = Many-t...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    Download this exampl PBIX solution from Onedrive

    Click here 

     

     

     

    Please click thumbs up for the suggestion,

    and click [accept solution] if it works.

     

    Your question is a bit vague, always provide an example desired output to clarify what is required.

     

     

parry2k's avatar
parry2k
Super User
1 year ago

Olwin see the attached solution, in nutshell, you need the following two measures:

 

Planning Qty = SUM ( ShipmentPlanning[Quantity] )

Total Shipment Planning = 
SUMX ( 
    SUMMARIZE (     
        OrderLines,
        'Item'[Items],
        Location[Location],
        "@Planning Qty", [Planning Qty]
    ), 
    [@Planning Qty] 
)