Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
jaume
1 day, 11 hours 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 1 times
...
uno96
2 days, 22 hours 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 1 times
...
MonikaStop
2 months ago
Selected Answer: B
I think B
upvoted 1 times
...
nelrosell
2 months, 1 week ago
Beeeeeee
upvoted 1 times
...
shedi13
2 months, 1 week ago
I would say thats A, beacuse you can change summarization on total to average
upvoted 1 times
...
b92fc92
2 months, 1 week ago
Selected Answer: B
In my opinion, B
upvoted 1 times
...
Jayaruwan
2 months, 1 week ago
Selected Answer: B
B is the correct answer. It wants to calculate average not the total
upvoted 1 times
...
rcaliandro
2 months, 2 weeks ago
Selected Answer: B
B. Average per category
upvoted 1 times
...
Endeetheanalyst
2 months, 2 weeks ago
B is the answer.
upvoted 3 times
...
jiheneB
2 months, 2 weeks ago
Selected Answer: B
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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