Question: what is the difference between sum and sumx?
Answer: In the video below, we will go through: how to use SUM() and SUMX(), the difference between them and when should we use one vs the other. The DAX SUM function calculates the sum of all numbers in a column while the DAX SUMX function returns the sum of an expression for each row in a table.