PL-300 · Question #401
You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters. You need to calculate the average item price for a given country…
The correct answer is B. Average per category. The 'Average per category' quick measure calculates the average of a base value (item price) broken down by a category (country), while respecting any active report filters - which satisfies all stated requirements. It generates a DAX measure using AVERAGEX over the category…
Question
You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters. You need to calculate the average item price for a given country. The solution must support the existing filters. Which type of quick measure should you use?
Options
- ATotal for category (filters applied)
- BAverage per category
- CRolling average
- DWeighted average per category
How the community answered
(61 responses)- A10% (6)
- B82% (50)
- C5% (3)
- D3% (2)
Explanation
The 'Average per category' quick measure calculates the average of a base value (item price) broken down by a category (country), while respecting any active report filters - which satisfies all stated requirements. It generates a DAX measure using AVERAGEX over the category values, making it filter-context aware. 'Total for category (filters applied)' (A) sums rather than averages. 'Rolling average' (C) is a time-intelligence calculation for moving averages over a date range, not a category breakdown. 'Weighted average per category' (D) weights the average by a secondary measure (like quantity), which introduces a factor not asked for in this scenario.
Community Discussion
No community discussion yet for this question.