Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Wrong sum

I have a shipment dataset that contains a Quantity (total ordered) and a Quantity Shipped column. I have added a calculated column using DAX for Outstanding Quantity (Quantity - Quantity Shipped) an...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Greg. I found this article by you - https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Used the methodology in the article but issue persists. This is my m_single -

This is my m_total - 

Outstanding Qty (column 2) is a calculated column (Quantity - Quantity Shipped). Outstanding qty m_single and m_total are measures. I put them side by side for comparison. The correct outsanding qty for my selection here is = 3+5+15+25+30 = 78, the sum of the outstanding qty column. But both the m_single and m_total columns are giving me incorrect totals. Could you please point out if there are any mistakes in my m_single/m_total formulas?

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng