How to calculate average per day

Try this

Average for Thursday = calculate(Average(TableName[Pages]),TableName[Day]="Thu")

Hi bryan_d,

   if you only want the average for one day the solution provided by MattAllington is the best.

While if you are searching for the average for every day you can try this:

1) you can visualize the day column like a table (and sort it by the "DayOfWeek(no)" column)

2) after that you can create a measure with this formula:  averagePages = AVERAGE(yourTable[Pages])

3) and you obtain this:

Let me know if it works (and if it's what you were searching for).

#I'M Not An Expert#

I'm looking for something similar but average per month