Forum Discussion
Solved
How to create a AVERAGE for a Text Column
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 ...
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
Hi, MooseButt
Have you tried using the AVERAGEX function?
Something like
=AVERAGEX(yourtable, COUNTROWS(yourtable))
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.
