Solved: Re: Formula help

bmadden2 · ‎10-23-2024

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 · ‎10-23-2024

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
)

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

View solution in original post

KNP · ‎10-23-2024

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
)

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!