DAX to average a measure?

[Anonymous]

I have a table with the columns "ID" ,"month" , "score" and "publish date". I have a measure that gets me the "average score per publish date" and then I just filter by ID on my report page.

What I ultimately want, is to use the values in the measure "averge score per publish date"  to calulcate the average score per month.

Here's a table as an example

ID	Score	Publish Date	Month
1	90	9/14/2022	September
1	60	9/14/2022	September
1	75	9/15/2022	September
1	85	9/15/2022	September

What I want but do not know how to do.

Step 1. Averge score per publish date 9/14/2022

90+60 = 150/2= 75

Step 2. Average score per publish date 9/15/2022

85+75= 160/2 = 80

Step 3. Average score per month. ( using average score per publish date to calculate)

80+75= 155/2 = 77.5

What I know how to do but do not want.

Step 1. Average score per month( using scores to caluclate)

90+60+85+75 = 77.5

Here is also the DAX formula that I used to get the average score per publish date.

Average Score Per Publish Date =

CALCULATE(

AVERAGE ( 'Table'[Score] ),GROUPBY('Table','Table'[Publish Date], 'Table '[ID]),

[PaulDBrown · Accepted solution]

Try:

Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])