Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
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.

 

 

Thanks

 

Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    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.