PowerPivot Denali new DAX function to rank (RANKX)

In Denali we introduced a new function to RANK a column based on a measure. In this blog post I will show you how to use the RANKX function to rank the values of a measure.

Lets look at this scenarion:

I have salesamounts per regions sliced by year: