1 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
)| 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!
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!
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
