Question 122 of 388
Single answerYou 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.
✓
Correct Answer: A
Add a Top N filter to the visual.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.