Forum Discussion
Rank AVG for the data subset
Hi kubaalbrecht ,
You just need to change the code in step 2 to
= Table.AddIndexColumn(Table.Sort([allrows], {"Sets diff", Order.Descending}), "DiffRank",1)The other steps remain the same and get the same result.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello.
Thank you very much for your help. Reading this seems clear a working solution BUT ...
On my working computer I have older version of Power BI with no rights to manage upgrade by my own, all the SW is managed centrally by IT department.
And in my current version of Power BI the function "Table.AddRankColumn" is missing. Do you have any idea how to solve the issue without this funtion?
Thank you once more for your help.
Hi kubaalbrecht ,
You just need to change the code in step 2 to
= Table.AddIndexColumn(Table.Sort([allrows], {"Sets diff", Order.Descending}), "DiffRank",1)
The other steps remain the same and get the same result.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! Works as desired. Only performace is not as great but that is not crucial for me.
Hello, once more.
Sorry for continue asking. I though I will be able to continue on my own, but fortunatelly I am not.
Now I would like to add one more column defining the result of every single player in a every single tournament:
- value "winner" if the ranking of the player is the lowest ranking in the single tournament
- value "loser" if the ranking of the playes is the highest ranking in the single tournament
- value "middle" in other cases
Can you please help me in this excercise as well?
Thank you.
Hi kubaalbrecht ,
If you have the same number of people for each tournament, then you can create the following custom column.
= if [DiffRank] = 1 then "winner" else if [DiffRank] = 4 then "loser" else "middle"If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizHello, thank you for you answer.
Unfortunally the task is not as easy because of the shared rankings and average rankings.
For example:
- winner:
- if a single person has the lowest ranking (= the highest difference between sets won and sets lost), then winner's ranking = 1
- if two persons have the lowest ranking, then both winners' ranking = 1.5
- if three persons have the lowest ranking, then all the winners' ranking = 2
- the same way for losers:
- a single loser: ranking 4
- two shared losers: ranking 3.5
- three shared losers: ranking 3
When you check rankings above, it is obvious that:
- ranking 2 may be winner or middle based on the ranking of other players in the same tournament
- ranking 3 may be loser or middle based on the ranking of other players in the same tournament
That is why a simple static condition considering only single player's ranking is not enough. Context of the ranking of other players within the same tournament must be considered.
So what I am asking for:
- "winner" is the player whose ranking equals the lowest ranking of the certain tournament
- "loser" is the player whose ranking equals the highest ranking of the certain tournament
- "middle" is the player who is not winner nor loser (= whose ranking does not equal lowest nor highest ranking of the certain tournament)
Thank you for your help.
- winner: