topic Re: Incorrect Measure Total in Developer

Incorrect Measure Total

py1029 — Wed, 17 Nov 2021 04:17:06 GMT

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.

Re: Incorrect Measure Total

Anonymous — Mon, 22 Nov 2021 02:23:07 GMT

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

Re: Incorrect Measure Total

py1029 — Mon, 22 Nov 2021 05:31:30 GMT

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!