Forum Discussion

therealomacoder's avatar
3 years ago
Solved

Ranking Based Upon Column in Scope, Ties Broken based upon another measure, Don't Rank Blanks()

Yes, another ranking question! After 2 days of reading and debugging on my own, I've decided it's time to ask you gurus. How do I fix my ranking so that it ranks all the way to #10, rather than stop...
  • therealomacoder's avatar
    3 years ago

    Well isn't that funny - I guess it just took me writing out all of the steps and digging into the problem in a bit more detail helped me find the solution.


    ALLSELECTED, in all occurrences, vs ALL.

     

    "If you forget to ignore the filter context and use VALUES instead of ALLSELECTED, then..."

     

    Discovered here.

    This is by far the best write up I've found of Rankx over the past couple days that I've been looking.