Exam Preparation Quiz

Explanations for each answer:

• AVERAGEX is correct. AVERAGEX iterates over a table, evaluating an expression for each row and calculating the average. This ensures the measure works properly with CALCULATE and respects the filter context.
• KEEPFILTERS is correct. KEEPFILTERS can be used inside CALCULATE to combine external and internal filters without overwriting them, which can be important for precise control of filtering behavior.
• AVERAGE is incorrect. AVERAGE calculates the arithmetic mean of a column in the current context, but does not evaluate an expression per row. It is not reliable when you need row-level calculations.
• ALL is incorrect. ALL removes filters, which can be useful in some advanced calculations, but it’s not appropriate here since the goal is to have the measure respect filters and slicers.
• CALCULATE is correct. CALCULATE adjusts filter context, which is often necessary when creating flexible measures that need to respond to report filters and slicers. It’s essential for many advanced measure scenarios.
• FILTER is correct. FILTER is used to create filtered tables within AVERAGEX or CALCULATE, allowing you to include or exclude rows as needed for precise calculations.
• SUMMARIZE is incorrect. SUMMARIZE groups data into summary tables, which is unnecessary when simply calculating an average profit measure.