Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@Anonymous , please find the file attached, after signature
@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])))
Thanks, How can I achieve the CUMULATIVE POINTS column based the previous description?
@Anonymous , can you share some sample-based data
Yes, thanks
YEAR | CYCLE | TEAM | POINTS | CUMULATIVE POINTS | RANKING |
2018 | 1 | A | 3 | 3 | 1 |
2018 | 1 | B | 1 | 1 | 2 |
2018 | 1 | C | 0 | 0 | 3 |
2018 | 2 | A | 1 | 4 | 1 |
2018 | 2 | B | 1 | 2 | 2 |
2018 | 2 | C | 1 | 1 | 3 |
Details:
Also the Ranking is based on CYCLE and YEAR
@Anonymous , please find the file attached, after signature
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |