Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
You have been tasked with creating a DAX measure to calculate the average overall satisfaction score from survey data. Here is the context for the tables involved:
- The Survey table records each submitted survey, with one row per survey.
- The Question table contains the text for each survey question.
- The Response table has one row for each question in every survey, capturing the responses.
The third question in each survey specifically asks for the customer's overall satisfaction score. Customers can submit a survey following each purchase. The data should be filtered to include only the surveys from the last 12 months, with this period being defined by the variable Period.
How should you complete the DAX code to achieve this? Choose the correct options in the provided answer area.
You have been tasked with creating a DAX measure to calculate the average overall satisfaction score from survey data. Here is the context for the tables involved:
- The Survey table records each submitted survey, with one row per survey.
- The Question table contains the text for each survey question.
- The Response table has one row for each question in every survey, capturing the responses.
The third question in each survey specifically asks for the customer's overall satisfaction score. Customers can submit a survey following each purchase. The data should be filtered to include only the surveys from the last 12 months, with this period being defined by the variable Period.
How should you complete the DAX code to achieve this? Choose the correct options in the provided answer area.
Explanation:
The correct DAX measure to calculate the average overall satisfaction score is 'AVERAGE('Survey'[Response Value])'. This is because the 'Response Value' field in the 'Survey' table contains the values that need to be averaged to get the satisfaction score. The use of 'AVERAGEA' with text fields or 'AVERAGEX' with customer keys is incorrect in this context. Additionally, 'Period' is not a function or aggregation method but a variable used to filter the data within the last 12 months. Therefore, the appropriate measure must use the 'AVERAGE' function on the 'Response Value' field.