For Box 1, the goal is to calculate the arithmetic mean of the satisfaction scores. The AVERAGE function is the standard aggregation function for this purpose, applied to the column containing the numerical scores ('Survey'[Response Value]). The AVERAGEX option provided is syntactically incomplete (missing the expression argument) and conceptually incorrect for a simple column average.

For Box 2, the CALCULATE function requires filter arguments to define the calculation context. The variable Period is defined earlier in the code using the DATESINPERIOD function, which returns a table of dates corresponding to the rolling 12-month window. In DAX, passing a table expression (like Period) into CALCULATE applies that table as a filter. The other options (NumberOfMonths, LastCurrentDate) are scalar values, which cannot be used directly as standalone filter arguments in CALCULATE.

Microsoft. (2024). CALCULATE function (DAX). Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/dax/calculate-function-dax

Microsoft. (2024). DATESINPERIOD function (DAX). Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/dax/datesinperiod-function-dax

Microsoft. (2024). AVERAGE function (DAX). Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/dax/average-function-dax