ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to 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 🗳️
by jiheneB at Sept. 4, 2024, 3:35 p.m.

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
Submit Cancel
desibaby09
5 months 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
5 months, 2 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
5 months, 2 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
7 months, 3 weeks ago
Selected Answer: B
I think B
upvoted 1 times
...
nelrosell
7 months, 3 weeks ago
Beeeeeee
upvoted 1 times
...
shedi13
7 months, 3 weeks ago
I would say thats A, beacuse you can change summarization on total to average
upvoted 1 times
...
b92fc92
7 months, 3 weeks ago
Selected Answer: B
In my opinion, B
upvoted 1 times
...
Jayaruwan
7 months, 3 weeks ago
Selected Answer: B
B is the correct answer. It wants to calculate average not the total
upvoted 1 times
...
rcaliandro
8 months ago
Selected Answer: B
B. Average per category
upvoted 1 times
...
Endeetheanalyst
8 months ago
B is the answer.
upvoted 3 times
...
jiheneB
8 months 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago