Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |