Power BI offers quite a few ways to spot the B.OST or WORST performers in your data, including RankX, Rank, and TOPN. An important thing to note is that RankX and Rank may need one more additional filter, either at the visual level or within a measure. As against this, TOPN gives a straightforward way to retrieve and filter data.

Example

TOPN is not the ideal choice when you need to identify the second top or second from the bottom performers. While it can easily return the top or bottom 2, it doesn’t offer flexibility for retrieving other specific ranks like the second.

Of these, probably the most versatile was the Index function, which was rolled out in December 2022. This can let you identify, without having to add any other filters or measures, not only the top performer but the second, third, and so on.

Here are some examples

To get the TOP performer:

To get the BOTTOM performer:

To get the SECOND TOP performer:

Doing it this way allows you to use the INDEX function to analyze your data flexibly and efficiently, without a lot of extra, complex filters or measures.