Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning,
In order to learn Power BI, I am creating an App that analyses the results of my local poker league.
My data model can be seen in the attached image
I have created a measure that SUMS the points earned by players during the 2nd season of our local poker league with the measure:
Season Total Points = SUM(Results_Final[Points])
If I create a table that lists the players and the measure and then filter by season (Name), I can see the results are correct.
I would like to create (I assume a Measure) have a table that has the dimension [Name], therefore showing all the seasons that have occured so far, and in the second column I would like to show the winner of that season (so therefore to effectively find the [Player] with the maximum Season Total Points from the measure defined above). In the instances of a tie, the winner can be just taken from the first alphabetically of the Players with the most total points.
Please can someone help me with how I would achieve this?
Solved! Go to Solution.
Hi @Greg_Deckler,
Thank you very much for the reading. Will definitely take a deep dive into it a bit later. I have actually managed to achieve the results using the following formula:
Season Winner = FIRSTNONBLANK(TOPN(1,VALUES(Results_Final[Player]),[Season Total Points]),1)
That said, once again thank you very much for your response and blog!
Kind regards,
Paul
@PaulVanS This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.
Hi @Greg_Deckler,
Thank you very much for the reading. Will definitely take a deep dive into it a bit later. I have actually managed to achieve the results using the following formula:
Season Winner = FIRSTNONBLANK(TOPN(1,VALUES(Results_Final[Player]),[Season Total Points]),1)
That said, once again thank you very much for your response and blog!
Kind regards,
Paul
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |