Microsoft Exam DA-100 Topic 10 Question 11 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 11
Topic #: 10

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.
D18912E1457D5D1DDCBD40AB3BF70D5D

Show Suggested Answer

Suggested Answer: A

Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.

Note:

Select the Column you want to display the Top Sales Profit

Then change the Filter Type of that Column to Top N

Fill in Top / Bottom number field

And lastly drag to the By Value filed your Sales Profit

https://www.tutorialgateway.org/power-bi-top-10-filters/

by Kenneth at May 06, 2022, 09:26 AM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!