Forum Discussion

BSimmers's avatar
BSimmers
Frequent Visitor
1 year ago
Solved

Using the RANKX Function...return 1

Hi there - I am having trouble getting my RANKX function to work. I returns 1 for every row. See below, I am trying to do a rank by the ABSDayonDayPrice column. Any help would be welcome. Thanks, Ben...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Wrap the sum() in calculate() to for context transition to occur

  • Deku's avatar
    Deku
    1 year ago

    replace ALL with ALLSELECTED

BSimmers's avatar
BSimmers
Frequent Visitor
1 year ago

That worked!! Thanks!

 

You might be able to assist with my next question...I need it Ranked by business date, it is currently ranking across all dates.

 

 

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

replace ALL with ALLSELECTED

  • BSimmers's avatar
    BSimmers
    Frequent Visitor
    1 year ago

    Thanks....again! this worked! Although ranked in the right order, I am getting false ties:

     

     

    • Deku's avatar
      Deku
      Icon for Super User rankSuper User
      1 year ago

      Try running on column(s) rather than table i.e. allselected(table[code]) so the sum is calculated on the required grain