subtracting two columns

[Anonymous]

Hey guys,

Im trying to compute a very easy dax that i cant compute.

Im just trying to substract two columns fom the same table with the follow dax:

dZ2Cantidad = sum('Z2'[Cons. Qty.])- sum('Z2'[Prod.Net.Qty.])

The result i am getting is (4.599.271,34) when it should be (2.303.276)

What  i am doing wrong?

Thanks in advance

[Anonymous]

Can you please share your data or sample power BI file?