Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Solved! Go to Solution.
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
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
Life Saver
That did it Qiuyun Yu! Thank you for your support!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |