exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 86 discussion

Actual exam question from Microsoft's PL-300
Question #: 86
Topic #: 2
[All PL-300 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Lulu_2022
1 week, 6 days ago
Selected Answer: B
Why this is the best choice: "Average per category" is designed to calculate the average of a measure (like item price) within each group (like country), while respecting all existing filters in the report. It dynamically adjusts based on slicers or visual-level filters, so if a user selects a specific country, the average reflects only that country’s data.
upvoted 1 times
...
Lulu_2022
2 weeks, 6 days ago
Selected Answer: B
The "Average per category" quick measure calculates the average of a selected measure (like item price) within the context of a category (like country), while respecting all existing filters in the report. This makes it ideal for your scenario, where you want to compute the average item price per country, and ensure that any slicers or filters applied to the report are honored.
upvoted 1 times
...
desibaby09
7 months, 2 weeks ago
Selected Answer: 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
upvoted 1 times
...
jaume
7 months, 4 weeks ago
Selected Answer: 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
upvoted 2 times
...
uno96
7 months, 4 weeks ago
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.
upvoted 2 times
...
MonikaStop
10 months ago
Selected Answer: B
I think B
upvoted 1 times
...
nelrosell
10 months ago
Beeeeeee
upvoted 1 times
...
shedi13
10 months ago
I would say thats A, beacuse you can change summarization on total to average
upvoted 1 times
...
b92fc92
10 months, 1 week ago
Selected Answer: B
In my opinion, B
upvoted 1 times
...
Jayaruwan
10 months, 1 week ago
Selected Answer: B
B is the correct answer. It wants to calculate average not the total
upvoted 1 times
...
rcaliandro
10 months, 1 week ago
Selected Answer: B
B. Average per category
upvoted 1 times
...
Endeetheanalyst
10 months, 1 week ago
B is the answer.
upvoted 3 times
...
jiheneB
10 months, 2 weeks ago
Selected Answer: B
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...