Menu
CoddyTech
Start learning

Ranking with RANKX

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 16 of 24.

RANKX(table, value): 1 for the highest value.

Category Rank = RANKX(ALL(Products[Category]), [Revenue])

It works out the value for each row of the table, then places the current one.

Rank against ALL, or each bar is ranked against itself.

challenge icon

Challenge

Write Category Rank: each category's place by Revenue, 1 for the highest. It is checked for each category.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?
quiz iconTest yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATEA Filter Replaces a FilterSeveral Filters at OnceKeeping FiltersRecap - Member Drink Sales

4DAX You Can Read

Variables with VARChoosing with SWITCHSWITCH(TRUE()) for RangesOne Value or ManyRows or the TotalChecking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes FiltersPercent of TotalRemoving One FilterKeep One Filter: ALLEXCEPTShare of What Is ShownRecap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXXFILTER Picks RowsMeasures Inside IteratorsRanking with RANKXRecap - Profit Without Columns