Continuing Ranking on a New Page

[AaronGlenn10]

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 ranking across four pages so I can export to a PDF and share with some folks who are not PowerBI users.  Screenshot below -- really appreciate your guidance! 

[mahoneypat · Accepted solution]

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

[AaronGlenn10]

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!

[AaronGlenn10]

Pat-

Thank you so much -- about to give it a try & will keep you posted!

[AaronGlenn10]

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.