Rank with report filter

• Derek-2008

  SSC Enthusiast

  Points: 176

  More actions

  October 21, 2013 at 9:32 am

  #148316

  I have a simple rank that I am doing same as http://www.powerpivotblog.nl/powerpivot-denali-new-dax-function-to-rank/

  Problem is I need the rank to "re rank" when someone filters so if I have a rank of 1 to 10 and I filter out 1 I need a rank of 1 to 9. RANKX leaves me with 2 to 10

• PB_BI

  SSCoach

  Points: 17463

  More actions

  October 28, 2013 at 7:18 am

  #1661949

  Instead of RANKX(ALL(whatever)

  You could use RANKX(ALLSELECTED(whatever)

  ---

  I'm on LinkedIn

• Derek-2008

  SSC Enthusiast

  Points: 176

  More actions

  October 29, 2013 at 6:24 am

  #1662317

  That was simple.

  Thank You

  Derek