Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 33 | |
| 29 | |
| 26 |
| User | Count |
|---|---|
| 135 | |
| 103 | |
| 65 | |
| 61 | |
| 55 |