Rank within a group based on another table column

[TheWizardHunter]

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!

[TheWizardHunter · Accepted solution]

Many thanks Cory,

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

[CoreyP]

Try something like this:

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