Forum Discussion
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 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!
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
6 Replies
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 YuThat did it Qiuyun Yu! Thank you for your support!
Life Saver
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.
