Power Fx function
Sum — Power Fx function reference
Total a column.
Syntax
powerfx
Sum( Table, Formula ) / Sum( Number1, Number2, ... )
Examples
powerfx
Sum(Orders, Amount)
→ A number
powerfx
Sum(Filter(Orders, Status = "Paid"), Amount)
powerfx
Sum(colCart, Qty * Price)
Common mistakes & gotchas
- Formula can be any per-row expression, not just a bare column — the second example totals a line item on the fly with no stored calculated column.
- Sum is not delegable on most connectors — summing beyond the retrieved row limit only totals the rows already pulled locally.
Related Power Fx functions
From Math & aggregation