Averaging item price per country while preserving report filters with a quick measure
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?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
Average per category computes the mean of the chosen field grouped by a category field (country) within the existing filter context — no extra weight column and no filter override needed.
A report filtered by item, price, and country data must calculate the average item price for a given country while keeping the existing filters, so the quick measure type must compute an average inside the current filter context.
Reaching for weighted average when the word 'price per item' appears — weighted average requires a second numeric column to weight by, which the model does not offer, and it is unnecessary to answer a plain average question.
Community Discussion (11 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The Average per category quick measure generates a DAX expression that averages a base value (item price) grouped by a category (country), evaluated within the report's existing filter context. Because quick measures respect current filters by default, selecting it satisfies both the calculation and the must-support-existing-filters requirement with no additional design.Why the Other Options Are Wrong
Total for category (filters applied) sums the value instead of averaging it, so it answers a different question. Rolling average computes an average across a date window, which has nothing to do with per-country item pricing here. Weighted average per category (D) requires a weighting column to multiply by; the scenario provides no such column, and introducing one would be extra machinery for a plain arithmetic average.Community Comment Notes
One commenter argues for D because 'average item price' might want item counts factored in, but weighted average needs an explicit weight column the model does not have. A later comment answers B on the grounds that it is the only option that actually computes an average and keeps the existing filters, which reflects the overwhelming vote distribution.Official Reference
Related Analysis
Practice All PL-300 Questions
Access 116 questions with complete answers and detailed explanations.
View Full PL-300 Practice Test →