Average of a calculated measure

[jn123]

Hello! 

I have a dax measure: [Program Average]=ROUND(VALUE([SUM IMP]/[DISTINCT PROGRAM COUNT]),-2)

This is so I can see the average of a certain time period (say between 11pm-12am) if there's more than one program in that time period. I have these averages separated by months. 

For example: 

In September, there were 2 programs that ran in the 11pm-12am time period. Program 1 brought 2,300 and Program 2 brought 2,500. So the average for that time period in the month of September is 2,400. 

In October, there were 3 programs that ran in that time period. Program 1 brought 2,000, Program 2 brought 8,600 and Program 3 brought 3,700. So the average for that time period in the month of October is 4,700.

What I would like to do, is be able to see the average of September and October (and have the ability to add in more months as time goes on) for that time period. 

I created measure that is [Distinct Month Count]=DISTINCTCOUNT([Month])

And then my monthly average measure is [Multi Month Average]=[Program Average]/[Distinct Month Count]

It should be giving me (2,400+4,700)/2 = 3,550.. but it is giving me 3,150 instead, which is (((2,300 + 2,000) + (2,400 + 8,600) + (3,700))/3)/2)

Is there a way to fix this?

Thanks!

[PaulOlding · Accepted solution]

Hi @jn123 

How about something like..

Multi Month Average =
AVERAGEX(
    VALUES(Table[Month]),
    [Program Average]
)

[jn123]

Bless you!! That did it. Thanks!!!