cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

New Member

## 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!

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Life Saver

New Member

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

Employee

Hi, @MooseButt

Have you tried using the AVERAGEX function?

Something like

`=AVERAGEX(yourtable, COUNTROWS(yourtable)) `

Proud to be a Datanaut!

New Member

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.

Employee

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

Proud to be a Datanaut!