Forum Discussion

TheWizardHunter's avatar
TheWizardHunter
Regular Visitor
2 years ago
Solved

Rank within a group based on another table column

Hello All,

Would appraciate any help regarding creating a rank column in a table for a visual. I created a group using the group feature for a column "Flag (groups)", The table has another collumn called "Amount". The visual shows both the grouped Flag (groups) and Population columns which I sorted in ascending order.

I would like to add a ranked column to the visual that lists the order of Flag (groups) based on Amount.  I have triened ny DAX variations but keep getting either all 1s for the ranked column of error measure in DAX. I keep getting incorect numbers in the rank column sometimes as below screenshot.

 

Many thanks!

Need Help
  • TheWizardHunter's avatar
    TheWizardHunter
    2 years ago

    Many thanks Cory,

    I modified the formula to the below and it worked.
    Ranking = RANKX(
    ALLSELECTED('Table'[Flag (group)]),
    CALCULATE(SUM('Table'[Amount]))
    )

2 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    2 years ago

    Try something like this:

    Rank of Flag (groups) = RANKX( ALL( Flag (groups) ) , SUM( Amount) , DESC )

  • TheWizardHunter's avatar
    TheWizardHunter
    Regular Visitor
    2 years ago

    Many thanks Cory,

    I modified the formula to the below and it worked.
    Ranking = RANKX(
    ALLSELECTED('Table'[Flag (group)]),
    CALCULATE(SUM('Table'[Amount]))
    )