Calculate the number of machine order in a column but exclude when machine order has been cancelled

[AudeVazart]

Hello,

I am struggleling with a DAX formula for one of my measure.

I need to count the number of machine order that I have in a column "Machine Order  ID".

But I need to exclude from my calculation the machine orders which have been cancelled.

If a machine order is cancelled, the value in the row will negative. So in this case:

the rows for the machine order (100 $) and the cancellation (-100$) will cancelled each othe (=0).

Thanks a lot for your help.

Aude