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.

 

 

 

 

 

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

  • Deku's avatar
    Deku
    1 year ago

    replace ALL with ALLSELECTED

6 Replies

  • Deku's avatar
    Deku
    Super User

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

    • BSimmers's avatar
      BSimmers
      Frequent Visitor

      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
        Super User

        Hi,

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