cancel
Showing results for
Did you mean:
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.
5 REPLIES 5
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.
New Member

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

Microsoft

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.

Microsoft

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

Proud to be a Datanaut!

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors