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

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

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

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.

 

 

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

    Hi,

    Share the download link of the PBI file and show the expected result there.

  • 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