Count records filtered by different table and by slicer

[titanconsulting]

I have two tables that I need information out of but I want a bit of a circular calculation.

Games Table

Teams Table

I'd like the Teams table to serve as a summary table, but I have a good deal of fields I'd want to summarize from the games table (how many wins, point differences, conference games vs non-conference, etc).  I'd then like to read these summed amounts per team on the games table to evaluate games.  For instance, on any given game I could see the home teams total wins against the away teams total wins.

My problem is these two tables can't be linked easily.  The games table has teams that are both home and away.  I need to sum up both the W from the home games and the away games.  I'd also like to use slicers - by filtering in a calculate measure, the filters are ignored.  I'd like to be able to filter from both sides - I might filter for what conference a team is in and also filter for the season the game is played.

Does it boil down to some sort of calculate measure on the Teams table to sum up the wins - also a calculate measure on the Games table to show the calculation of both Home Team wins vs Away team wins?  Really struggling with a syntax that will work.

[PaulDBrown]

Can you please share sample non-confidential data and a depcition of the expected outcome?

[titanconsulting]

Source Data 

PHA+V2UgaGF2ZSBzdWNjZXNzZnVsbHkgZmluaXNoZWQgdGhlIHRlc3RpbmcgcGhhc2UsIHdoaWNoIGluY2x1ZGVkIGJvdGggZnVuY3Rpb25hbCBhbmQgbm9uLWZ1bmN0aW9uYWwgdGVzdGluZywgYW5kIGFyZSBjb25maWRlbnQgdGhhdCB0aGUgcGxhdGZvcm0gbWVldHMgYWxsIG9mIG91ciBkZXNpZ24gc3BlY2lmaWNhdGlvbnMuPC9wPgo8cD5DdXJyZW50bHksIG91ciB0ZWFtIGlzIHdvcmtpbmcgZGlsaWdlbnRseSBvbiB0aGUgZG9jdW1lbnRhdGlvbiwgd2hpY2ggaXMgaW4gcHJvZ3Jlc3MuIFdlIHVuZGVyc3RhbmQgdGhlIGltcG9ydGFuY2Ugb2YgY2xlYXIgYW5kIGNvbXByZWhlbnNpdmUgZG9jdW1lbnRhdGlvbiBmb3IgdGhlIHN1Y2Nlc3NmdWwgYWRvcHRpb24gYW5kIHVzZSBvZiB0aGUgcGxhdGZvcm0sIGFuZCB3ZSBhcmUgY29tbWl0dGVkIHRvIHByb3ZpZGluZyBvdXIgY2xpZW50cyB3aXRoIHRoZSBiZXN0IHBvc3NpYmxlIHN1cHBvcnQgbWF0ZXJpYWxzLjwvcD4KPHA+VGl0YW4gUE0gU29sdXRpb25zIGxhdW5jaCBkYXRlIGlzIHJhcGlkbHkgYXBwcm9hY2hpbmcgd2l0aCBxdWl0ZSBhIG51bWJlciBvZiBhY3Rpdml0aWVzIHRvIGFjaGlldmUuJm5ic3A7IE1vdmluZyBvdmVyYWxsIHN0YXR1cyB0byB5ZWxsb3cgdG8gc2hvdy48L3A+

Expected result

<p>We have successfully finished the testing phase, which included both functional and non-functional testing, and are confident that the platform meets all of our design specifications.</p>
<p>Currently, our team is working diligently on the documentation, which is in progress. We understand the importance of clear and comprehensive documentation for the successful adoption and use of the platform, and we are committed to providing our clients with the best possible support materials.</p>
<p>Titan PM Solutions launch date is rapidly approaching with quite a number of activities to achieve.&nbsp; Moving overall status to yellow to show.</p>

Results of using first method:

<p>We have successfully finished the testing phase, which included both functional and non-functional testing, and are confident that the platform meets all of our design specifications.</p>

No results for second method