Forum Discussion
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 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!
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
4 Replies
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.
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!
