Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rank based on Cumulative SUM Column

 

Hi, I have this table and I need to calculate the RANK by YEAR & CYCLE depending on the cumulative POINTS by YEAR

(In the example, The CUMULATIVE POINTS for CYCLE 2 are the SUM of POINTS from CYCLE 1 & 2.

 

 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Try like

    Year cycle team rank= RANKX(FILTER(ALL('Table'[Year],'Table'[Cycle],'Table'[Team]),'Table'[Year]=max('Table'[Year])
,'Table'[Cycle]=max('Table'[Cycle])),calculate(sum(table[CUMULATIVE POINTS])))
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, How can I achieve the CUMULATIVE POINTS column based the previous description?