Forum Discussion

kubaalbrecht's avatar
kubaalbrecht
Regular Visitor
4 years ago
Solved

Rank AVG for the data subset

Hello,   I have data about the scores of players in beachvolleyball tournaments:   Tournament ID Player Sets won Sets lost Sets diff Rank AVG 1 A 6 0 6 1 1 B 2 4 -2 3 1...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

     

Jos_Woolley's avatar
Jos_Woolley
Solution Sage
4 years ago

Hi,

Can you just clarify how you get your current expected results based on that dataset? Using Excel and calculating RANK.AVG for each of the values in the Sets diff column gives results widely different from those you give.

Regards

kubaalbrecht's avatar
kubaalbrecht
Regular Visitor
4 years ago

Hello,

 

I am trying to calculate the rank of every single player in a every single tournament regardless on the other tournaments. This means that I am not willing to calculate the rank accross all the tournaments, only within a single tournament. Cf. the problem Nr. 1 in my original post describing the same aspect as well.

 

I attach a screenshot containing the formula I would use in Excel. I need the same formula/function to covert to Power BI.

 

 

Screenshot from Excel describing the requested function to be converted to Power BI.

 

Further aggregations will be executed on top of this Ranking (e.g. "Which player has the smallest avarage ranking across all the tournaments?" as an simple average of the requested "Rank AVG tournaments ranking") but the is not the task and solving within this topic now.