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.

     

     

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi Olwin ,

To achieve your goal, you need to create a measure to look like this:

TotalShipmentPlanning = 
CALCULATE(
    SUM('Shipment Planning'[Quantity]),
    FILTER(
        'Shipment Planning',
        'Shipment Planning'[Item] = SELECTEDVALUE('Order Lines'[Item]) &&
        'Shipment Planning'[Location] = SELECTEDVALUE('Order Lines'[Location])
    )
)

 

Expected Output:

Please see attached file