Forum Discussion
Solved
Ranking a category (calculated column)
Hi, i have a pretty simple ranking issue im unable to resolve. In an example table i have 4 rows and 2 columns. A - 5 A - 7 B - 13 B - 4 I want rank these categories (A and B). How do...
is this what you want?
Column = RANKX(ALL('Table (2)'),CALCULATE(SUM('Table (2)'[VALUE]),ALLEXCEPT('Table (2)','Table (2)'[ID])),,DESC,Dense)
is this what you want?
Column = RANKX(ALL('Table (2)'),CALCULATE(SUM('Table (2)'[VALUE]),ALLEXCEPT('Table (2)','Table (2)'[ID])),,DESC,Dense)