Forum Discussion
Solved
Average each month
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. ...
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.
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.
This is perfect, thank you so much!