Microsoft Exam PL-300 Topic 15 Question 30 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 30
Topic #: 15

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

What should you do?

AAdd a Top N filter to the visual.

BConfigure the Sales Profit measure to use the RANKX function.

CAdd a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

DAdd a calculated column to the table that returns the city name if the city is in the top 10, otherwise the
calculated column will return 'Not in Top 10'. In the visual, replace Sales Profit with the calculated column.

Show Suggested Answer

Suggested Answer: A

by Joesph at Aug 28, 2023, 08:35 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sabra

3 days ago

I think option A is the most straightforward way to get the top 10 cities. It's a simple filter that will do the job without any additional calculations.

upvoted 0 times

...