How to get average of text column?

[Arioli_Chezhian]

Hi All,

I have a column which has 'user name' and it's datatype is 'text'. Currently I am showing the data in card visual which shows distinctcount of username.

However, I would like to show 'Average of number of users'. Since it is in text datatype, could you please advice on how to write the measure to achieve this scenario?

E.g. data:

Username

abc

def

ghi

[Anonymous]

@Arioli_Chezhian  What would your average be based on? For example, average number of users over time or average sales by user.

[Arioli_Chezhian]

@Anonymous  - In a card visual, just need to show the Average of number of users. May be you can consider as average number of users over time.

[Anonymous · Accepted solution]

@Arioli_Chezhian  This measure for example will calculate the average number of products, year over year. I recommend trying quick measures to learn things like this.

Average # of Products YOY =

AVERAGEX(

    KEEPFILTERS(VALUES('Date Table'[Year])),

    CALCULATE(COUNTA('Sheet1'[Product]))

)

[Arioli_Chezhian]

@Anonymous  - Thank you for your response.

Is it possible to get average of distinctcount instead of count?

[Anonymous]

Try replacing COUNTA with DISTINCTCOUNT