
Answer-first summary for fast verification
Answer: AVERAGE('Survey'[Response Value]), Period
The correct DAX measure to calculate the average overall satisfaction score is 'AVERAGE('Survey'[Response Value])' and 'Period'. This is because 'Response Value' is the numeric column containing the satisfaction scores, and 'Period' is the variable that filters the data to compute the average over the last 12 months. The other options are incorrect because they either use inappropriate fields for aggregation or have incorrect syntax.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In your role as a Fabric Analytics Engineer Associate, the task is to develop a DAX measure that calculates the average overall satisfaction score for a customer satisfaction report. This measure must fulfill several specific criteria:
Given these requirements, how should you complete the DAX code to achieve the desired outcome?
A
AVERAGE('Survey'[Response Value]), Period
B
AVERAGEA('Question'[Question Text]), NumberOfMonths
C
AVERAGEX(VALUES('Survey'[Customer Key]), LastCurrentDate
D
AVERAGE('Survey'[Response Value]), Period LastCurrentDate
No comments yet.