I can't seem to get the correct combination to get the measure that I want. I'm ultimately trying to find the amount of time each team spends in each area as a percent of the total time spent by both teams in any area (see below for some dummy data and the measure I have so far), averaged over the number of events there are.
Where I'm coming unstuck is that the ALL function doesn't seem to be removing the filters on area and team like I thought - I would have expected [TimeNotFiltered] to have given 93.3 in all cells in the matrix below, not just the total - [TimeFiltered] and [TimeNotFiltered] are giving the same results.
I tried using ALLEXCEPT(Table1, Table1[Event]) which worked in the case I'm describing above, but lost the other filters that I had available which I wanted to keep (minute and period).
I'm not sure where I am going wrong, any help would be really appreciated.