Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Am trying to Average product cost but my statistics menu has evrything greyed out except for count values and count distinct values
Any one to help am new to power bi
HI @Damsky2485 ,
Please check you column data type, current some of summarize mode only available on numeric value.(you can modify these fields type on format tab) For other types, you can use count,count distinct, first, last on them.
Regards,
Xiaoxin Sheng
@Damsky2485 it would be helpful to get some screenshots and possibly a bit more detail. With the added content I or someone else will hopefully be able to assist!
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 22 | |
| 21 | |
| 13 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 45 | |
| 45 | |
| 30 |