Power BI Tip: Handling Duplicate Rankings in DAX for Accurate Top 10 Visuals

Описание: Ever faced the issue of duplicate rankings when trying to display the Top 10 in Power BI? I recently tackled this challenge while creating a column chart to show the top 10 countries by a specific metric. Here’s a quick solution using DAX to get around duplicate rankings and ensure accurate results!

Step 1: Generate a Random Number

Randome = RAND()
Step 2: Create a Unique Rank Measure with DAX by adding a random number to the rank.


Step 3: Create a new measure to filter for the top 10 and apply it to your visual.

Step 4: Set the Filter on the Visual Add a Top N filter on the visual to display the top countries based on the new rank measure.

Filter Settings:

Filter type: Top N
Show items: Bottom 10
By value: [Rank for Top Country for Rates]