topic How to calculate all partially received goods by purchase order number in DAX Commands and Tips

How to calculate all partially received goods by purchase order number

OsvaldoFagundes — Wed, 24 Sep 2025 16:47:40 GMT

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

Re: How to calculate all partially received goods by purchase order number

GeraldGEmerick — Wed, 24 Sep 2025 20:52:51 GMT

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

Re: How to calculate all partially received goods by purchase order number

Praful_Potphode — Thu, 25 Sep 2025 02:32:25 GMT

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.

Re: How to calculate all partially received goods by purchase order number

OsvaldoFagundes — Thu, 25 Sep 2025 12:30:42 GMT

Hi Gerald!

Thanks for your help!

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

Re: How to calculate all partially received goods by purchase order number

OsvaldoFagundes — Thu, 25 Sep 2025 13:35:10 GMT

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!

Re: How to calculate all partially received goods by purchase order number

Praful_Potphode — Thu, 25 Sep 2025 14:00:52 GMT

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

Re: How to calculate all partially received goods by purchase order number

Anonymous — Tue, 30 Sep 2025 12:17:16 GMT

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.

Re: How to calculate all partially received goods by purchase order number

Anonymous — Sat, 04 Oct 2025 13:40:24 GMT

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

Re: How to calculate all partially received goods by purchase order number

Olufemi7 — Sun, 05 Oct 2025 05:39:44 GMT

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.

Re: How to calculate all partially received goods by purchase order number

Anonymous — Tue, 07 Oct 2025 05:02:49 GMT

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