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: Yesterday @ 7:51 AM
Points: 12, Visits: 103
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 480, Visits: 919
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: Yesterday @ 7:51 AM
Points: 12, Visits: 103
That was simple.

Thank You

Derek
Post #1509310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse