Average each month

[ArchStanton]

I have this table visual that Counts the volume of tickets.

I would like to show Average in the Total Column, is that possible?

My current Visuals are filtered as per the below images.

Thanks

[v-zhangti · Accepted solution]

Hi, @ArchStanton 

You can try the following methods. I simulated some data and hope to match your situation.

Measure = 
Var _table=SUMMARIZE('Table','Table'[FY],"Count",COUNT('Table'[ticketnumber]))
Return
AVERAGEX(_table,[Count])

You can also change the name of Total to Average.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ArchStanton]

This is perfect, thank you so much!