Rank Teams using RANKX

[Alta88]

How do you rank teams using the RANKX formula? The one we're using keeps returning a value of '1'. We have two teams in the department we're ranking (Strategic Ops and Quick Strike). The individual reps have been ranked, but the teams aren't following suit: 

Our formula is the following: 

Rank Team = RANKX(ALL('Merge1'[Teams]),CALCULATE(DISTINCTCOUNT('Merge1'[Teams])))

[v-chenwuz-msft · Accepted solution]

Hi @Alta88 ,

Please try this code to do this:

RankTeam = RANKX('Table',[Rank Rep],,ASC)

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alta88]

The expected result is to rank each team in ascending order based on how individual reps' rankings. Right now it returns only a value of '1'. One of the two teams will rank higher than the other per the Reps in each. Here's another version of the data: 

Teams	Rank Rep	Rank Team
Strategic Ops	18	1
Strategic Ops	20	1
Strategic Ops	61	1
Strategic Ops	70	1
Quick Strike	70	1
Strategic Ops	30	1
Strategic Ops	19	1
Strategic Ops	15	1
Strategic Ops	14	1
Strategic Ops	33	1
Strategic Ops	43	1
Strategic Ops	8	1
Strategic Ops	69	1
Quick Strike	20	1
Strategic Ops	90	1
Quick Strike	98	1
Quick Strike	33	1
Strategic Ops	19	1
Strategic Ops	15	1
Quick Strike	72	1

[TomMartens]

Hey,

what is the expected result based on the sample data you provided? Not to mention, that a picture can not be easily used to recreate the data to try something. I will not spend time on using screen reader to extract the data from pictures, sorry.

Regards,

Tom