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.

mattbrice's avatar
mattbrice
Solution Sage
8 years ago

I assumed that you only had 'Table[State]' and 'Table[CompanyName]' on the rows and 'Order Count' and 'Avg TAT BD' were already measures.   So the Rank measure as written should work.  I don't understand why you were getting an error. What specifically was the error you got, and what exactly was the measure you wrote?

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

 

  • mattbrice's avatar
    mattbrice
    Solution Sage
    8 years ago

    What is ‘Avg TAT BD’ measure you wrote?   Are there other table/page/report filters being applied to matrix?

  • 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] )
)