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.
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.
Hi @hafizsultan,
If you sort the column Year by itself instead of by the column Year Number, it will perform the ranking.
Result:
Hope it helps.
Daniel
Thanks Daniel for explanation. It solved my problem