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
Pat-
Thank you so much -- about to give it a try & will keep you posted!
I now have my top 100 list across four (4) seperate pages, but curious to know if there's a measure that will total the columns across the Top 100 - insert a 'total summary' in a 5th page.