Sum
Aggregation
Sum(column)
Adds the column over the rows in the current filter context (SQL SUM). NULLs are skipped; over zero rows the result is blank (NULL) — wrap in Coalesce([Measure], 0) when you want zeros.
When to use it
Section titled “When to use it”- Any how much in total question — revenue, quantity shipped, cost, hours logged.
- As the additive base other measures build on: ratios (
Divide), running totals (YTD,RollingSum), and filtered variants (Calculate) all accept it.
Example
Section titled “Example”Revenue := Sum(Sales.Amount)Good to know
Section titled “Good to know”- The argument is a column, not a measure —
Sum([Revenue])fails with SQX013; a measure already aggregates.