Hi,
It was ranking on the number of tickets.
I added the following and it seems to have worked also.
"
Solved/Closed Ticket Ranking =
VAR Currentmonth = 'Summary Table'[MonthYear]
VAR Currentteam = 'Summary Table'[Team]
VAR newtable = filter('Summary Table','Summary Table'[MonthYear]=Currentmonth && 'Summary Table'[Team] = Currentteam)
RETURN
if(not isBLANK('Summary Table'[Numer of Solved/Closed Tickets]),
rankx(newtable,'Summary Table'[Numer of Solved/Closed Tickets],,DESC,Dense))"
Thanks,
