Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a Rank

Hi,    I'm trying to create a ranking of the accounts count of this table.      That table is a duplicate of another table that has the real data. I created that table using the command "g...
COUNT
DAX
rank
ranking
RANKX
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    You can use this measure

     

    Rank Account Name = RANKX( ALL(Table3[Account Name]), CALCULATE(SUM(Table3[Count])),,DESC,Dense)

     

     

    Regards,
    Harsh Nathani

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi. Thanks! But I received the same number 1 for all accounts in the ranking 😞

AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago
Can you share the pbix file or the diagram view of your model?