I'd developing a Power BI report related to the sport cricket. Here's a few key terms.
Bowling = Throwing the ball at the batters. Equivalent to pitching in baseball.
Bowler = Player who bowls at the batters. Equivalent to the pitcher in baseball.
Runs = Total points socred against the bowler while he was bowling.
Wickets = Total number of opposition players who were out when the bolwer was bowling.
Suppose following is a sample data set for a 10 game career.
Game,Runs,Wickets
1,23,5
2,34,0
3,55,1
4,13,0
5,43,3
6,45,3
7,64,6
8,45,6
9,24,2
10,34,1
There's a term called 'Best Bowling' for a player. It's the game in which a bowler took most wickets while giving away fewest runs. What this essentially means is the top record(s) when first sorted DESC by wickets, then sorted ASC by runs.
In this sample data, there are two instances of MAX wickets: games 7 and 8. Between those, game 8 has fewer runs. So that's the bowler's best performance. In a case where in both games runs were equal as well (say, both at 64), then both records are considered best performances. This value is generally displayed in the following format:
45/6
I would like to create a measure where it goes through the career record of a player and find the best bowling performance and displays it in the above format. What's the best way to go about it?
