Subcategory Ranking

Question

Hi All,&nbsp;I have an interesting scenario were I have to Rank Team members based on Team. Below is just an example.Please help. Thank you! &nbsp;TeamsAgentsScoreRankTeam 1Agent 8961Team 1Agent 6402Team 1Agent 5153Team 1Agent 18124Team 2Agent 6781Team 2Agent 7781Team 2Agent 4692Team 2Agent 18173Team 3Agent 131001Team 3Agent 20623Team 3Agent 3782Team 4Agent 171191Team 4Agent 15792Team 4Agent 2523Team 4Agent 16464Team 5Agent 7901Team 5Agent 6792Team 5Agent 1773Team 5Agent 17554Team 5Agent 14435Team 5Agent 12106&nbsp;RegardsSohail

sokg · Accepted Answer

Hi Sohail&nbsp;you must create a new column and write&nbsp;Rank = RANKX(FILTER(Table1;Table1[Teams]=EARLIER(Table1[Teams]));Table1[Score];;;Dense)&nbsp;and the result is :&nbsp;

Forum Discussion

Subcategory Ranking

2 Replies

Related content

Ranking in subcategories

Duplicate ranking

Measure for rank by subcategory

Ranking by subcategory

Rank with conditions

Teams	Agents	Score	Rank
Team 1	Agent 8	96	1
Team 1	Agent 6	40	2
Team 1	Agent 5	15	3
Team 1	Agent 18	12	4
Team 2	Agent 6	78	1
Team 2	Agent 7	78	1
Team 2	Agent 4	69	2
Team 2	Agent 18	17	3
Team 3	Agent 13	100	1
Team 3	Agent 20	62	3
Team 3	Agent 3	78	2
Team 4	Agent 17	119	1
Team 4	Agent 15	79	2
Team 4	Agent 2	52	3
Team 4	Agent 16	46	4
Team 5	Agent 7	90	1
Team 5	Agent 6	79	2
Team 5	Agent 1	77	3
Team 5	Agent 17	55	4
Team 5	Agent 14	43	5
Team 5	Agent 12	10	6