Hi, I'm pretty new to power bi and dax, but haven't had luck with finding an example that fits what I'm trying to do.
I'm trying to get the following - I've created a new measure as shown in the image below. I've put the results into a matrix with Event as columns and Team as rows and the values come out fine, however what I want for the total column for each team is the Average of Events as opposed to performing the measure without respect to the events.
I think I need some combination of Calculate, Group By or summarize, but I haven't been able to wrap my head around how to get what I want. Any help would be welcome!