The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
12 | |
4 | |
2 | |
2 |