Table Average Required

[ArchStanton]

The following code gives me the Average for each month going back 3 Financial Years (FY exists in my Date Table)

Averages = 
            VAR _table = SUMMARIZE(Date2,Date2[FY],"Count",COUNT('Cases'[incidentid]))
            RETURN
            AVERAGEX(_table,[Count])

How Do I replace the total below with an overall monthly Average?

Thanks

[amitchandak · Accepted solution]

@ArchStanton , try a measure like

AVERAGEX(values(Date2[Month]),[Averages])

or

AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))

[ArchStanton]

Many thanks, they both work perfectly!