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!

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , why allexpect

 

Rank =
RANKX (
ALL ( 'Tabla Account Count'[Account Name] ),
CALCULATE (
COUNTROWS ( 'Tabla Account Count' ),
),
,
DESC,
DENSE
)

 

this will rank for COUNTROWS ( 'Tabla Account Count' )

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The following error appears :

 

Argument '2' in CALCULATE function is required 

 

I don't know exactly what to put since I'm new in DAX 😕