Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rank with report filter Expand / Collapse
Author
Message
Posted Monday, October 21, 2013 9:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 30, 2014 7:19 AM
Points: 12, Visits: 104
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
Post #1506723
Posted Monday, October 28, 2013 7:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 632, Visits: 1,210
Instead of RANKX(ALL(whatever)
You could use RANKX(ALLSELECTED(whatever)





I'm on LinkedIn
Post #1508861
Posted Tuesday, October 29, 2013 6:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 30, 2014 7:19 AM
Points: 12, Visits: 104
That was simple.

Thank You

Derek
Post #1509310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse