What is difference between SUM and SUMX?

Question

Accepted Answer

SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression over a table.

SUM is used to calculate the sum of a column or expression in Power BI.
SUMX is used to calculate the sum of an expression over a table in Power BI.
SUM is typically used with a column reference, while SUMX is used with an expression.
SUMX can be used to perform calculations on filtered or modified data.
Example: SUM([Sales]) calculates the sum of the Sales column, while SUMX(Sales, [Sales]*[Quantity]) calculates the sum of the expression [Sales]*[Quantity] over the Sales table.

Accepted Answer

SUM - is an application on a single column and creates a single summing of a column & a single column is combined into one value via aggregator functions

SUMX - is an Iterator function, row by row iterations and evaluations are completed by iterator functions

Accepted Answer

Sum is the summarise of one single column and Sumx is used to summarize the columns with expression.

What is difference between SUM and SUMX?

Top Infosys Power BI Developer interview questions & answers

Popular interview questions of Power BI Developer

Top HR questions asked in Infosys Power BI Developer