Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MooseButt
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.  DAX Average.png  

 

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;

DAX Average II.png

 

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
v-qiuyu-msft
Community Support
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])

 

w2.PNG

 

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.

View solution in original post

6 REPLIES 6
v-qiuyu-msft
Community Support
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])

 

w2.PNG

 

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.

Life Saver

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

Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi, @MooseButt

 

Have you tried using the AVERAGEX function?  

 

Something like 

 

=AVERAGEX(yourtable, COUNTROWS(yourtable)) 

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.  

HI @MooseButt

 

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.