How to calculate all partially received goods by purchase order number

[OsvaldoFagundes]

Hi my friends!

Please, how do I calculate all quantities received by purchase order number?

In the example below, I received item P/N 24431 on three different dates (10,000 per delivery) with Purchase Order 318431 and need to show this cumulative received in the "TotalReceived" column. In this case it should be displayed as 30,000 units from TotalReceived:

Best Regards!

OFilho

[v-nmadadi-msft]

Hi @OsvaldoFagundes 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[Olufemi7]

Hi @OsvaldoFagundes 

 You can solve this using a DAX measure that calculates the cumulative quantity received per PONumber.

Here's how:

TotalReceived =
CALCULATE(
    SUM(Sheet1[Received]),
    ALLEXCEPT(Sheet1, Sheet1[PONumber])
)

This measure:

• Sums all Received values.
• Groups the sum by PONumber, so each row with the same PO shows the same total.
  
  

[v-nmadadi-msft]

Hi @OsvaldoFagundes 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @OsvaldoFagundes ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Praful_Potphode]

Hi @OsvaldoFagundes ,

Please try below measure:

PONumber Total = CALCULATE(
    SUM('Table'[Received]),
    ALLEXCEPT('Table','Table'[PONumber])
    )

output will look like below:

You can experiment with allexcept to try different columns subtotals.

please mark it as resolved once confirmed.

[OsvaldoFagundes]

Hi Praful!

Thanks a lot my friend!

Unfortunately it doesn't work. I got 60,000 instead of 30,000 🙄

It appears that the value of the quantity received is doubling. Take a look at other PO:

Best Regards!

[Praful_Potphode]

Hi @OsvaldoFagundes ,

can you provide sample data so that i can try again?

based on screenshots it lookslike we  have to include PartNumber column also.

Please try below measure:

PONumber Total = CALCULATE(
    SUM('Table'[Received]),
    ALLEXCEPT('Table','Table'[PONumber],'Table'[PartNumber])
    )

if this doesnt work,please send me sample data here or dm me directly

thanks and regards,

praful

[GeraldGEmerick]

@OsvaldoFagundes I believe that something like this should work:

TotalReceived =
VAR _PONumber = MAX( 'PurchaseOrder'[PONumber] )
VAR _Return = CALCULATE( SUM( 'PurchaseOrder'[Received] ), FILTER( 'PurchaseOrder', [PONumber] = _PONumber ), ALL( 'PurchaseOrder' ) )
RETURN _Return

[OsvaldoFagundes]

Hi Gerald!

Thanks for your help!

I applied your measure, but it didn't work. For PO 318431 it would return 30,000: