Forum Discussion
Ranking DAX
Hi, I have this table: - One Year has different Cycles - There are some Teams with Points in those Cycles I need to have the ranking of those teams based on the SUM of Points made i...
Like this?
Hi Thanks , is almost like that but the TEAM needs to be consider to SUM the Points of each TEAM in the CUMULATIVE POINTS
10+30, 20 +15, 5+2 Is this how you want?
Exactly , ranking bases on all the teams in one specific Round and Year
That's simple you could use this:
But the 40,35,7 values needs to appear only in the CYCLE 2, because the cumulative points are related to Campaign / Cycle/ Team