I'm building a Power BI dashboard for ATP tennis stats. I have raw data in CSV format, which as a ton of fields, but narrowed down to relevant stuff for this question, it looks like this. I have full stats for all ATP games, but I narrowed down to Grand Slam finals in the last few years in order to give you a smaller sample data set.
This is all good, and if I want to get the number of wins by player etc, I could easily do that using COUNT of winner column. But I'd like to do more, such as total number of matches played for each player, or win percentage for each player, to name a few. In the above data set, if you take Dominic Thiem for instance, he's played in 4 slam finales and won 1 for a win percentage of 25%.
With a data set arranged like this, how do I create a table, for instance that has columns [ Player, Matches Played, Wins, Losses, Win % ]? Do I need to create a new column for Player and double the data set size? I tried using Measures but not quite sure how to go about it.