Incorrect Measure Total

[py1029]

Hi,

I have a table as below. The columns of zOreder Qy, zAccum Deliver and zPending are all measures. Value in zPending is obtained by subtracting zAccum Deliver from zOrder Qty (zOrder Qty - zAccum Deliver = zPending). 

Would like to ask how to get the correct Total for column zPending? I already tried with SUMMARIZE, SUMX and HASONEVALUE. All of these couldn't give me the correct Total. 

Is there any other methods in getting the correct Total? 

Thanks. 

[Anonymous]

Hi @py1029 ,

Please create another new measure as below  and put the new measure onto the table visual to replace the current one [zPending]:

New Measure = SUMX ( VALUES ( 'Table'[PO ID] ), [zPending] )

In addition, you can refer the method in the following links to resolve it.

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If the above ones can't help you get the correct total pending values, please provide some sample data(exclude sensitive data) and the formula of measure [zOrder Qty] and [zAccum Deliver]. Thank you.

Best Regards

[py1029]

Hi @Anonymous 

Thanks for your reply. I still couldn't get the correct total pending values with this measure. 

Here attached the sample data and the measures that I used in the table. 

"Order Qty" is the total quantity ordered for the particular PO. 

"Receipt Date" is the date that received the quantity amount. 

When I select the period (for e.g. Aug-2021):

I would like to know the total pending quantity to be delivered for each PO on next month (Sep-2021). 

Hence, I got all these measures to calculate the accumulated delivered quantity until 14th day of each month and pending quantity to be delivered for the next month of period select.

Next, I created a measre to filter the order that left to be delivered on Sep-2021. [First day of the month] would be 1-9-2021 while [Last day of the month] would be 30-Sep-2021. 

When I apply new measure to get the total pending values, it still couldn't work. 

Hope the information that I provided might help to understand more. Your help is much appreciated.

Thanks!