Forum Discussion
Solved
Average selected data (Athletes' performances)
Hi there, I have a list of athletes, events and performances and I would like to average the performances of each athlete in a specific event. The following is an example of the dataset: Competi...
Hi Flotenva, looks like you are missing the ALL line from my code example.
I think i get what you are after. You would need to use the "Create Column" and try something like this:
AveragePerformance = Calculate(
Average('Table'[Performance]),
all('Table')
'Table'[Event] = EARLIER('Table'[Event]),
'Table'[Name] = EARLIER('Table'[Name])
)I hope that might create what you are chasing.
Hi Ross,
I have done what you suggested:
Rank = CALCULATE(
AVERAGE('Athletics (ParseHub)'[Mark]),
'Athletics (ParseHub)'[Name]=EARLIER('Athletics (ParseHub)'[Name]),
'Athletics (ParseHub)'[Event]=EARLIER('Athletics (ParseHub)'[Event])
)
But I'm getting exactly the same value as in the column [Mark]...