RANKX for ranking in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the RANKX function do in Power BI?

RANKX assigns a rank number to each item in a list based on a value, like sales amount, showing who is first, second, and so on.

intermediate

What is the basic syntax of RANKX?

RANKX(Table, Expression, [Value], [Order], [Ties]) where Table is the list to rank, Expression is the value to rank by, Value is optional, Order is ascending or descending, and Ties decides how to handle equal ranks.

intermediate

How does RANKX handle ties by default?

By default, RANKX gives the same rank to tied values and skips the next ranks accordingly.

advanced

Can RANKX rank items within a filtered group?

Yes, by using FILTER inside RANKX or applying filters to the table, you can rank items within specific groups like regions or categories.

beginner

Why is RANKX useful in dashboards?

It helps show top performers, like best-selling products or highest revenue customers, making data easy to understand and compare.

What does the RANKX function return?

A Sum of values

B A rank number for each item

C Average of values

D A filtered table

RANKX returns a rank number showing the position of each item based on the expression.

Which argument in RANKX defines the order of ranking?

A Order

B Expression

C Table

D Value

The Order argument sets if ranking is ascending or descending.

How does RANKX treat ties by default?

A Assigns the same rank and skips next ranks

B Assigns different ranks randomly

C Assigns the same rank and does not skip ranks

D Ignores ties

By default, RANKX assigns the same rank to tied values and skips the next ranks.

Can RANKX be used to rank within a specific group like a region?

A No, it ranks all data only

B Only with calculated columns

C Yes, by filtering the table inside RANKX

D Only if data is sorted

You can filter the table inside RANKX to rank within groups.

Which of these is a common use of RANKX in reports?

A Calculating averages

B Filtering data

C Creating charts

D Showing top sellers

RANKX is often used to show top sellers or top performers.

Explain how you would use RANKX to show the top 5 products by sales in a Power BI report.

Think about ranking all products by sales and then filtering to keep only the top 5.

Describe how RANKX handles ties and how you might change this behavior.

Consider what happens when two items have the same value and how to control ranking order.