How to create a AVERAGE for a Text Column

[MooseButt]

I have a table that has a text column that I can use the COUNT DAX function, but now I want to take an AVERAGE of that count.    

The 'Request:Request Name' column is what I have as my COUNT column, but now I would like to create an AVERAGE in my visual;

Any suggestions?  I think I have to create a new column/measure that aggregates the values, so that I can use the AVERAGE ability in my value options.  

Any assitance is great!

[v-qiuyu-msft · Accepted solution]

Hi @MooseButt,

Do you mean you want the Total returns average values? For example, the first row of the matrix, (2479+2562)/2=2520.5. 

If it is, you can create a measure below: 

Measure = var temp=SUMMARIZE('Table1','Table1'[Edited By],'Table1'[Edit Date].[Month],"CountVal",COUNTROWS('Table1'))
return
AVERAGEX(temp,[CountVal])

Best Regards,
Qiuyun Yu 

[MuthalibAbdul]

Life Saver

[MooseButt]

That did it Qiuyun Yu!  Thank you for your support!

[Phil_Seamark]

Hi, @MooseButt

Have you tried using the AVERAGEX function?  

Something like 

=AVERAGEX(yourtable, COUNTROWS(yourtable)) 

[MooseButt]

Thanks for the quick reply Phil.  I attempted to use the AVERAGEX formula and the result returned the total number of entries in the column.  Very similar to what I already have in my table.  I tried to change the type from Count to Average, but it didn't give me the option.  

[Phil_Seamark]

HI @MooseButt

Any chance you can share a cut down PBIX file to help?