Difference between sum() and sumx()

Question

Accepted Answer

sum() is used to calculate the sum of a column, while sumx() is used to calculate the sum of an expression evaluated for each row.

sum() is an aggregation function that calculates the sum of a column in a table.
sumx() is an iterator function that calculates the sum of an expression for each row in a table.
sumx() is useful when you need to perform calculations on a row-by-row basis, while sum() is used for simple column summation.
Example: sum(Sales[Amount]) calculates the total sales amount, while sumx(Sales, Sales[Amount]*Sales[Quantity]) calculates the total revenue by multiplying amount and quantity for each row.

Popular interview questions of Power BI Developer