Forum Discussion
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 ...
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 RegardsLucien
v-luwang-msft
Community Support
Community SupportHI 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