Ranking function issue!

DAX DAX Calculations
1

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

2

03.30 - Customers and toys.pbix (2.1 MB)

3

Hi @hafizsultan,

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

aa
aa.png1338×327 33.9 KB

Result:

bb

Hope it helps.

Daniel

3 Likes
4

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

5

Hi @hafizsultan, glad it worked out for you.

Daniel