Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

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's avatar
AaronGlenn10
Helper III
4 years ago

Pat-

 

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

  • AaronGlenn10's avatar
    AaronGlenn10
    Helper III
    4 years ago

    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.