Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Guys,
I have a dataset with a list of football games.
Games List:
Home Team | Away Team |
Sweden | France |
France | USA |
Canada | France |
Sweden | Canada |
I have few questions about it.
From this column I would like to calculate few things:
Thank you in advance for those who will have a look. Thank you so much 🙂
Maxime
Hi @Rampeur ,
Create the home and away tables as slicers,then create measures like below:
home or away = CALCULATE(COUNTROWS(FILTER('Games List','Games List'[Home Team]=SELECTEDVALUE(Home[Home Team])&&'Games List'[Away Team]=SELECTEDVALUE(Away[Away Team]))))
either home or away = CALCULATE(COUNTROWS(FILTER('Games List','Games List'[Home Team] in {SELECTEDVALUE(Home[Home Team]),SELECTEDVALUE(Away[Away Team])}&&'Games List'[Away Team]in {SELECTEDVALUE(Away[Away Team]),SELECTEDVALUE(Home[Home Team])})))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for answering but this is not what I want.
How would you create a slicer (1 single one) with the list of countries and Then you get a bar chart with the top 5 of teams they play against.
so you filter on sweden, then you get
France: 9
Brazil 6
Norway 5
for example.
Hi,
You should first of all Unpivot your dataset so that all teams appear in a single column and another column (with the title of Attribute) specifies the type of team.
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |