Forum Discussion
Total games played!
One option would be to do some manipulation in Power Query. First, add an index column called Match ID. Then create a new query which references the first, called Home Games. Use the Choose Columns functionality to select only the columns which relate to the home team, and add a new column "Home / Away" which simply contains "Home".
Repeat the above, again referencing the original query, but this time choosing the columns for the away team, and setting the Home / Away column to Away.
You can now append the new queries so you have 1 table, and all your measures will only need to look at a single column, and you can filter for home or away.
You can right-click on the original query and untick Enable Load so that it doesn't appear in your report, it will only be used to populate the appended queries.