Rank of month

[Ashish_Mathur]

Hi,

For sheer simplicity, i have just one table called Calender with consecutive dates, year, month number, month name and day of week.  In the slicer, i have selected the year as 2019.  In the Table visual, i have dragged Year and Month Name from the Calender Table (the only table in the PBI file).  I have then written a measure called Month of current row = MONTH(MIN(Calender[Date])).  No problem so far.  Now i want to rank the month names (in ascending order) by writing a measure.  So the answer i am expecting to see is numbers from 1 to 12 (same as the month numbers).  However, when i write this measure, then i get all 1's

Measure = RANKX(ALL(Calender[Month Name]),[Month of current row])

Where is my mistake?

Thank you for your help.

[AntrikshSharma · Accepted solution]

Measure =
RANKX (
    ALL ( Dates[Month] ),
    CALCULATE ( [Month of Current row], ALLEXCEPT ( Dates, Dates[Month] ) ),
    ,
    ASC
)

[Ashish_Mathur]

Thank you.