Forum Discussion

CourtneyB's avatar
CourtneyB
Frequent Visitor
8 years ago
Solved

RANKX Help!

Hi Everyone,   I am hoping someone can help me becausebecause this RANKX is really giving me a run for my money. I am fairly new to Power Bi and have been teaching myself as I go and I have hit a w...
  • CourtneyB's avatar
    CourtneyB
    8 years ago

    Hi All, 

     

    So, my boss was able to figure it out. the correct formula to use for my case is the following:

     

    Rank = RANKX(ALLSELECTED('2821_410_700_150'[CompanyName]), CALCULATE(AVERAGE('2821_410_700_150'[TT100150_CD])),,ASC,Dense)-1

     

    Thank you for all your imput and assistance.

CourtneyB's avatar
CourtneyB
Frequent Visitor
8 years ago

Example of what I am looking to accomplish except a new column would be entered with the rankings

mattbrice's avatar
mattbrice
Solution Sage
8 years ago
RANKX ( ALL (Table[Company] ), [Avg Tat BD] )
  • CourtneyB's avatar
    CourtneyB
    Frequent Visitor
    8 years ago

    mattbrice it is not allowing me to enter the [avg TAT BD]. In the matrix, i have the TAT BD to average and not sum if that makes a difference?