Explain the difference between SUM() and SUMX().

Question

Accepted Answer

SUM()
            SUMX()
        
        
            Adds values from a column.
            Evaluates an expression row by row.
        
        
            Simple aggregation.
            Iterator function.
        
    

    Total Revenue =
SUMX(
    Sales,
    Sales[Quantity] * Sales[UnitPrice]
)

    SUMX is commonly used for business calculations.

SUM()	SUMX()
Adds values from a column.	Evaluates an expression row by row.
Simple aggregation.	Iterator function.

Explain the difference between SUM() and SUMX().

Answer with Explanation