Learn how to calculate the average item price for a given country in a Power BI report using filters. Discover which quick measure type supports existing filters for this calculation.
Table of Contents
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?
A. Total for category (filters applied)
B. Average per category
C. Rolling average
D. Weighted average per category
Answer
B. Average per category
Explanation
When you need to calculate the average item price for a given country while supporting the existing filters in your Power BI report, the most appropriate quick measure to use is “Average per category.”
This quick measure calculates the average value of the selected measure (in this case, price) for each category (in this case, country) while respecting the filters applied to the report. It takes into account the filtered context and provides the average price for each country based on the data available after the filters are applied.
The other options are not suitable for this scenario:
- “Total for category (filters applied)” calculates the sum of the measure for each category, not the average.
- “Rolling average” calculates the average over a specified number of periods, which is not relevant to the given requirement.
- “Weighted average per category” calculates the average based on the weight of each category, which is not mentioned in the question.
Therefore, to calculate the average item price for a given country while supporting the existing filters in your Power BI report, you should use the “Average per category” quick measure.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.