Passing filter result to second table - SELECTEDVALUE?

BigPatJennings

New Member
Joined
Aug 25, 2014
Messages
13
Hi, I have a football database I'm trying to convert from Excel to Power BI. One of the sections is a record of the result of one team's games against another, home and away. Each team plays each other twice, as you know. My score data is in a flat file as you can see below.
Score Table.JPG

Making a table of a team's home games is simple. I've created two identical flat files, one called HomeTeam and the other called AwayTeam and they list all possible teams once, and have a one-to-many relationship with the scores table. I use two slicers, one for the home team and one for the away team, and the file looks like this. (I've stripped out a lot of the data to make it easier to read - HS = Home Score, AS = Away Score).

2slicer.JPG


This shows the results when Brighton have played at home to Tottenham in the past three seasons. I would like to also show the results when the match was reversed and Brighton were away. It doesn't have to be the same table, but it has to be on the same worksheet. I'm guessing this requires a variable and selectedvalue from the original slicers, but every attempt I've made hasn't worked so far. I've tried adapting a formula I saw on Curbal but again, no luck. I'd be grateful if someone could help.

Thanks
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,809
Messages
6,174,761
Members
452,582
Latest member
ruby9c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top