Averaging item price per country while preserving report filters with a quick measure

PL-300 By islever Editorial Last updated

Create model calculations by using DAX

Short answer

B Average per category computes mean item price grouped by country inside the existing filter context.

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?
  1. Total for category (filters applied)
  2. Average per category Correct Answer
  3. Rolling average
  4. Weighted average per category

Key Takeaways

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.

Common mistake: 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.

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

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

This link opens the official vendor documentation in a new tab.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 11 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 11

  1. jiheneB 👍 3 Answered B
    https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
  2. jaume 👍 2 Answered B
    This is the only solution calculating the average as requested. Other options are calculating "rolling" and "weighted" average or total price. Since ew must keep existing filters, there is no need to use CALCULATE function there
  3. uno96 👍 2
    i am sure D because The Weighted average per category quick measure ensures the correct calculation of the average item price for a specific country, supporting existing filters and maintaining data context.
  4. desibaby09 👍 1 Answered D
    it says average ITEM price which could want to include the number of items in the formula. The answer choice B does not allow us to use that information
  5. shedi13 👍 1
    I would say thats A, beacuse you can change summarization on total to average
Show 6 more comments
  1. Jayaruwan 👍 1 Answered B
    B is the correct answer. It wants to calculate average not the total
  2. Endeetheanalyst 👍 3
    B is the answer.
  3. rcaliandro 👍 1 Answered B
    B. Average per category
  4. b92fc92 👍 1 Answered B
    In my opinion, B
  5. MonikaStop 👍 1 Answered B
    I think B
  6. nelrosell 👍 1
    Beeeeeee

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

PREVIOUSYEAR returns the full previous year, not the same day of last year

S-grade

Shrinking a Power BI model for monthly transaction totals with a star schema

S-grade

Northwind Traders semantic model: choosing Import storage mode for the Power BI tables

S-grade

Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector

S-grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide