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

Ashish_Mathur I'm sorry, I do not know how to create a link for you to download the file. I have played around more with the data and got the formula to mostly work except there isnt a rank 1 populating. Here are some screenshot detail that hopefully will help

 

Current RANKX Formula

 

Visualization DetailsSnapshot of dataMeasure for Avg TAT BD being used

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.