Microsoft Power BI Data Analyst — Question 110

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?

Answer options

• A. Total for category (filters applied)
• B. Average per category
• C. Rolling average
• D. Weighted average per category

Correct answer: B

Explanation

The correct choice is B, 'Average per category', as it directly calculates the average while considering the existing filters. Options A and D do not specifically focus on calculating an average, while C, 'Rolling average', is not suitable for the requirement of a static average calculation for a specific country.