Which DAX function would you use to calculate total sales?

The SUM() function is ideal for calculating total sales because its primary purpose is to add together a column of numerical values. When you want to find the total sales amount in a dataset, using the SUM() function allows you to specify a column that contains the sales figures, and it efficiently computes the total by summing all the values within that column.

In contrast, the AVERAGE() function calculates the mean of a set of values, which does not directly provide a total but rather an average figure. COUNT() is used to count the number of entries in a column and is not suitable for aggregating numerical sales data. MAX() identifies the highest value in a set but doesn’t deliver a total aggregation. Therefore, when the goal is to find the total sales amount, the SUM() function is the most appropriate choice.