Skip to main content

“I have a sales table with a measure called ‘Gross.’ The sales table is linked to the geography table via the City ID column. The geography table includes columns for City ID, City, and State. I have created the following measure

Table of Contents
Rank = RANKX(ALL(Geography[City]), [Gross]) 

Rank is by default descending in the case of RANKX function.

Also remember, Skip is also a default option from Skip and Dense. There is a new rank function available now, and their rank is by default ascending.

Add comment