Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the sum of an expression evaluated for each row in a table.
SUMX(<table>, <expression>)
Term | Definition |
---|---|
table |
The table containing the rows for which the expression will be evaluated. |
expression |
The expression to be evaluated for each row of the table. |
A decimal number.
The SUMX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers you want to sum, or an expression that evaluates to a column.
The SUMX is an iterator function.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored.
For more complex examples of SUMX in formulas, see ALL and CALCULATETABLE.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example first filters the table, InternetSales, on the expression, 'InternetSales[SalesTerritoryID] = 5`, and then returns the sum of all values in the Freight column. In other words, the expression returns the sum of freight charges for only the specified sales area.
= SUMX(FILTER(InternetSales, InternetSales[SalesTerritoryID]=5),[Freight])
If you do not need to filter the column, use the SUM function. The SUM function is similar to the Excel function of the same name, except that it takes a column as a reference.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today