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.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI CourtneyB

 

Give this a shot

 

Rank =
RANKX (
    ALL ( '2821_410_700_150'[State], '2821_410_700_150'[CompanyName] ),
    AVERAGE ( '2821_410_700_150'[TT100150_BD] )
)
CourtneyB's avatar
CourtneyB
Frequent Visitor
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.