Forum Discussion
Solved
Struggling with Ranking
I have a table called 'Sites' with the following columns OrganisationID SiteID Date Started Time to Start 4 1044 28/06/2018 38 4 1045 25/04/2012 10 4 1048 10/01/2024 40 ...
Rank = var a = SUMMARIZE(ALLSELECTED('Table'),[OrganisationID],"R",[Average Time to Start]) return rankx(a,[Average Time to Start],,ASC) Average Time to Start = AVERAGE('Table'[Time to Start])
So the end result I am looking for would do this...
| OrganisationID | Average Time to Start | Rank |
| 6 (Big Bill's Buffalo Ranch) | 6.00 | 1 |
| 7 (Tiny Tim's Tiger Emporium) | 7.00 | 2 |
| 3 (Loud Lucy's Lion Zoo) | 25.00 | 3 |
| 4 (Grim Gary's Giraffe Safari) | 29.33 | 4 |
Rank =
var a = SUMMARIZE(ALLSELECTED('Table'),[OrganisationID],"R",[Average Time to Start])
return rankx(a,[Average Time to Start],,ASC)
Average Time to Start = AVERAGE('Table'[Time to Start])