Average over months

[NewbieJono]

Hello all, i have used the average trend line to work out the average for this visuaul.

what wold the dax be to work out average myself? the counts in this charts are based on count rows in a table

[NewbieJono]

Thank you, is there a method i could add a thrid metric to this. for example department

[ray_aramburo · Accepted solution]

Try adding that column after 

'Table'[MonthColumn]

[ray_aramburo]

Try this:

Average Ovr Months = AVERAGEX(SUMMARIZE('Table','Table'[MonthColumn]), CALCULATE(COUNTROWS('Table')))