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

mattbrice I have added the measure to do Avg TAT BD instead of formating it to be average in the matrix and now it let me use it in the RANKX formula however it is not populating the ranks correctly

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi CourtneyB,

 

Share the link from where i can download your file.

  • 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.