Forum Discussion
NewbieJono
Post Partisan
Post PartisanAverage over months
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
Try adding that column after
'Table'[MonthColumn]
3 Replies
- ray_aramburo
Super User
Try this:
Average Ovr Months = AVERAGEX(SUMMARIZE('Table','Table'[MonthColumn]), CALCULATE(COUNTROWS('Table'))) 
NewbieJonoThank you, is there a method i could add a thrid metric to this. for example department
- ray_aramburo
Try adding that column after
'Table'[MonthColumn]