Average of Average

[Anonymous]

Hi All, 

I am trying to figure out how to approach this calculation. 

I have three measures per day. I need to average each days average and then take the average of those averages over a given time. 

Day	Item1	Item2	Item3	Average
Monday	1	1	3	1.66666667
Tuesday	2	2	2	2
			Avg. Of Avg	1.83333333

What I am ultimately looking for is the number that is in red. I can do this in excel super quick but cant seem to rationalize how to get the same result in PowerBI. 

Perhaps I am overthinking this but I cant seem to work this one out! 

THanks, 

Nick 

[Anonymous]

I didnt properly lay out how my data is formatted. It is more like what is below.

What I want to calculate is the numbers in red ultimately. 

I already have the "yellow" and "Blue" groups set up with relationships. 

The average section is the sum of time / sum of calls. So it is actually a averate time/call type measurement. 

Any thoughts?

[Anonymous · Accepted solution]

I used GROUPBY to create a DAX table and then calculated the Average per line. I was then able to use this. Thanks for the ideas guys!!! 

[Anonymous]

hi, 

If the value in red is all you need, just insert a measure. 
Measure = AVERAGE('name of your table'[Average])

[Anonymous]

I think you are struggling because of how your data is set up ( assuming what you put below is how it is set up).  But going off that just did a simple unpivot other column in Power Query:

Then it's just a simple average formula:

Avg = AVERAGE('Avg of Avg'[Value])