Issue with RankX function - giving Rank 1 for all the records of Month Name by Sales

[Shv]

I am trying to create a line chart for Top N Sales amount by Month.

When I use RankX function to Rank the Sales by Month Name it gives same rank for all 12 months.

Below is the DAX:

Rank_TopN = RankX(ALL(financials[Month Name]), Calculate(Sum(financials[Sales])), , Desc,Dense)

Any suggestions would be appreciated 🙂

Thanks!

[Shv]

Hi @danextian ,

Thanks for the solution and quick response!
It worked 🙂

[danextian · Accepted solution]

Hi @Shv ,

Is Month Name a text string and being custom sorted by an other column? If so, include that in ALL as well.

https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/