cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prakash11440278 Regular Visitor
Regular Visitor

Average Ticket Count

 

Hi All,

 

I am facing an issue, while calcualating the Average of Ticket numbers. Where this can be done by using the Count Function but i am not able to calcualte using Average. Ticket Key format is "INC0001233467", which is text data type. Is there any alternate method i can calcualte the average of ticket numbers. Attatching the Error Screen shot.

 

image.png 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Average Ticket Count

@prakash11440278,

 

Check if AVERAGEX Function works in your case.

https://community.powerbi.com/t5/Desktop/Change-table-visualization-total/m-p/323290#M144103

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prakash11440278 Regular Visitor
Regular Visitor

Re: Average Ticket Count

Hi