BenchMark Quizzes by MDFT Pro

Show Top Five Products With Highest Churn Rates

At MDFT Academy, you create a report about course completion rates and student dropout rates. The academy is interested in identifying which courses have the highest dropout rates to improve student retention.

You need to restrict the visual to show the top five courses with the highest dropout rates. What should you do to achieve this in your Power BI report?

Choose all correct answers from the options below.

Explanations for each answer:

Create a measure using the TOPN DAX function is correct. TOPN returns the top five records based on a measure; you may still need to sort the visual to display them in descending order.
Create a measure using the RANKX DAX function is correct. RANKX returns the top five records and provides a rank for ordering from highest to lowest.
Use the Q&A Visual is incorrect. The Q&A visual allows users to ask questions and get quick insights, but it does not create permanent visuals that can be shared in a report. Therefore, it is not suitable for restricting a report visual to the top five courses for sharing with MDFT Academy.
Apply Top N filter on Visual is correct. A visual filter with TOP N setting can show the top five products in a visualization.

Learn more about filtering visuals in Power BI:

Power BI Visual Filters

Exam Preparation Quiz

Show Top Five Products With Highest Churn Rates