Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

RANKX columns

This is my data.  I created two columns 1) "S&P Rank Usage": ranks the accounts within a quarter by the "Numeric S&P with Median" 2) "Exp Rank by Credit Usage": ranks the "S&P Rank Usage" by ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    HI Anonymous ,

    Try to test create new column like the below:

    EXP_RANK = RANKX('Table','Table'[S&P Rank Usage]+0.00000000000001*'Table'[Exposure],,DESC,Dense)

     

    It will rank first by S&P Rank Usage,if S&P Rank Usage with the same value ,then rank by  exposure.

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

No, rather what I would want to see in a new column would be that top row (with S&P Rank 14) to be #1.  Then all of the rows with S&P rank 12 would be #2-6, then the 11's would be #7-9 and so on.  So that there is only one of each number.