A Deep Dive Into RANKX

RANKX is a scalar DAX function in Power BI that allows you to return the ranking of a specific number in each row of a table that forms part of a list of numbers. In this video, Harsh is going to deep dive into the RANKX function and analyze some important and most common scenarios you’ll encounter that requires for this foundational function.

***** Video Details *****
00:00 Introduction
01:31 Customer ranking
02:13 Cities ranking v1
05:02 Territories ranking
07:38 Cities ranking v2
08:09 Products ranking
09:18 DAX studio

***** Related Links *****

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #RANKX #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

[qasimjan]

Hi Harsh really like your videos on ranking concept you 've been doing as a series over the last couple of weeks and hammering it to a deeper level. I wish you do a Calculate and Iterator series as well. Thanks

[cesarsaldana]

Hi, your content is of great value, you should have more likes, greetings from Mexico.

[welcometomathy]

I want to go ranking of products overtime month by month. Total year rank vs last month, month current vs previous. TopN last year products current rank.

[sagarnaidu]

total also getting rank 1 so need to remove total ranking can you tell me