Subtraction of two columns not showing the correct values

[MP-iCONN]

I have an issue with two columns I am trying to subtract from.

One column is called Required Qty and the other is called Original Blanket Qty.  

I created a measure called Unscheduled Blanket Qty:

Unscheduled Blanket Qty = CALCULATE(SUM('Sales Orders'[Original Blanket Qty])) - SUM('Sales Orders'[Required Qty])

As you can see from the screenshot the 2nd line does NOT appear to be subtracting correct.  I tried a bunch of different options but not sure how to get the math to be correct.

Any help is greatly appreciated!

Thank you.

Chad

[Anonymous]

Hi @MP-iCONN 

Your formula works well on my side, you can refer to my pbix file. If possible, please provide your pbix file so that we can find the cause of the problem .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@MP-iCONN 

maybe you can try

SUM('Sales Orders'[Original Blanket Qty]) - SUM('Sales Orders'[Required Qty])

you can use measures to display the first two columns to check if returns the correct result and do the calculation between these two measures.

[MP-iCONN]

Same issue.

I did a SUM measure for both Blanket Qty and Required Qty and then added in my Unchscheduled Blanket Qty with the SUM('Sales Orders'[Original Blanket Qty]) - SUM('Sales Orders'[Required Qty]) measure and still the same value where it is not subtracting the 1820 from 910 correctly.

[ryan_mayu · Accepted solution]

@MP-iCONN 

pls try this

measure = max('Table'[orignial blanket qty])-max('Table'[rquired qty])

Measure 2 = sumx('Table',[measure])

[MP-iCONN]

I tried this and the MAX seemed to work for measure1 (Unscheduled Blanket Qty) but then I did the SUMX of that Measure1 and still off.

Unscheduled Blanket Qty = MAX('Sales Orders'[Original Blanket Qty]) - MAX('Sales Orders'[Required Qty])

Unscheduled Blanket Total = SUMX('Sales Orders',[Unscheduled Blanket Qty])

Thank you for your help so far! 

[ryan_mayu]

@MP-iCONN 

since i can't reproduct the issue, could you pls provide some sample data and expected output?