Ranking function issue!

Hi,

I am trying to calcuate very simple rank by year but somehow it is not working. What can be the reason of it? It is always showing Rank as 1 for all years. This measure works fine for other dimensions.

I have attached my .pbix file.

image

03.30 - Customers and toys.pbix (2.1 MB)

Hi @hafizsultan,

If you sort the column Year by itself instead of by the column Year Number, it will perform the ranking.

Result:

bb

Hope it helps.

Daniel

3 Likes

Thanks Daniel for explanation. It solved my problem :slight_smile:

Hi @hafizsultan, glad it worked out for you.

Daniel