Show the goals when your team is either away or home

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

I got an interesting question last night in preparation for the world cup. How can I get a PivotTable where I can see the results where the team selected in a slicer is either the Home or the Away team. Because we need to do show games where the Home or the Away team are selected here we cannot use traditional relationships. This is the table of games I have (yes its fake, I made it myself before you wonder if these games are actually played):

Read more...

Tags: dax, design

 

2007-2015 VidasSoft Systems Inc.