Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

 

 

 

1111.jpg

1 ACCEPTED SOLUTION

@Anonymous , please find the file attached, after signature 

 

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@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
Not applicable

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

@Anonymous , can you share some sample-based data

Anonymous
Not applicable

Yes, thanks

YEARCYCLETEAMPOINTSCUMULATIVE POINTSRANKING
20181A331
20181B112
20181C003
20182A141
20182B122
20182C113

 

Details:

222.jpg

Also the Ranking is based on CYCLE and YEAR

@Anonymous , please find the file attached, after signature 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.