Forum Discussion
Solved
Continuing Ranking on a New Page
All Stars: I have page with a Top 25 sales ranking - but, would like to continue the ranking up to 100 on subsequent pages 26 - 50, 51 - 75, and 76 - 100 respectively. I'm needing to seperate the r...
You can use a measure like this one and adapt it for each page to the rank range of interest.
Top25 Sales =
VAR vThisRank =
RANKX( ALL( Project[Project] ), [SalesMeasure],, DESC )
RETURN
IF( vThisRank >= 1 && vThisRank <= 25, [SalesMeasure] )Pat
You can use a measure like this one and adapt it for each page to the rank range of interest.
Top25 Sales =
VAR vThisRank =
RANKX( ALL( Project[Project] ), [SalesMeasure],, DESC )
RETURN
IF( vThisRank >= 1 && vThisRank <= 25, [SalesMeasure] )
Pat
Is there a way to add reference # column so readers can identify the rankings?
So each location would have a rank # in front of their name based on their respective rank.
Thank you!