Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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!