Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

calculating values from multiple columns

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...
Need Help
Tips and Tricks
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.