Which DAX function is used to iterate over a table and return a single scalar value by applying an expression to each row?

Question

Power BI — Hard

Which DAX function is used to iterate over a table and return a single scalar value by applying an expression to each row?

Accepted Answer

The SUMX function is used to iterate over a table, applying an expression to each row and returning a single scalar value. This is because SUMX combines the iteration with aggregation. Other functions, like FILTER, only filter rows without applying an expression.