Forum Discussion

Flotenva's avatar
Flotenva
Frequent Visitor
9 years ago
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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Flotenva, looks like you are missing the ALL line from my code example.

Flotenva's avatar
Flotenva
Frequent Visitor
9 years ago

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]...

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Flotenva, looks like you are missing the ALL line from my code example.

  • Flotenva's avatar
    Flotenva
    Frequent Visitor
    9 years ago

    Thank you so much!!