Forum Discussion

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

Frequent Visitor

8 years ago

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

Resolver V

8 years ago

Hi CourtneyB, can you show us your latest version of RANKX formula ?

CourtneyB
Frequent Visitor
8 years ago
DAX0110 I didnt have anything established as i kept getting errors but with mattbrice's formula and adding Average() it just gave me all Rank 1s. I dont know if it makes a difference but each row in the data gives the order level Turn Time, so when i pull that field into the matrix i have it average instead of sum.

Rank = RANKX(ALL('2821_410_700_150'[CompanyName]),AVERAGE('2821_410_700_150'[TT100150_BD]))
- 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
    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

Related content