Touchdown Problem Solved, and COUNTROWS
In the last post I was struggling with horribly-designed source tables. To be honest, I never found a way to relate those two tables to each other, even through other intermediate tables that initially seemed promising.
But I DID find two columns in my Plays table itself that saved my bacon – [OffensiveTeamScoreAtPlayStart] and [OffensiveTeamScoreAtPlayEnd].
A simple calc column subtracting the two and now I have [PtsScoredOnPlay]: