Question: what is the difference between sum and sumx in dax?
Answer: 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.