Forum Discussion
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 c...
Many thanks Cory,
I modified the formula to the below and it worked.
Ranking = RANKX(
ALLSELECTED('Table'[Flag (group)]),
CALCULATE(SUM('Table'[Amount]))
)
Try something like this:
Rank of Flag (groups) = RANKX( ALL( Flag (groups) ) , SUM( Amount) , DESC )