Formula help

[bmadden2]

Hi New user here, attemting to  learn by jumping in and doing.

I need to complete the formula to only select records greater than 0. (>0)

How do I finish the formula?

Balance To Invoice = ((DNI[QTY_SHIPPED]-DNI[QTY_INVOICED]) * DNI[SALE_UNIT_PRICE])

Thanks

[KNP · Accepted solution]

If I understand you correctly, something like this should work.

Change the last column to suit your scenario.

Balance To Invoice = 
CALCULATE(
    SUMX (
        'DNI',
        ('DNI'[QTY_SHIPPED] - 'DNI'[QTY_INVOICED]) * 'DNI'[SALE_UNIT_PRICE]
    ),
    'DNI'[YourColumnToFilter] > 0
)