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

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

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
Employee
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.