Forum Discussion
All statistics greyed out in Power Query
This appears to be a glitch associated with the setting Options > Global > Report Settings > Customize Appearance.
Setting this option to anything other than "Legacy" causes this glitch along with others including disabling the Power Query quick-access toolbar.
I've already placed some feedback and you may want to as well:
Do you want to create a new column? what's the expected output?
No, I just want to create an aggregate statistic of the count of values or count of distinct values for a text column. The statistics button is greyed out for any text column I select. I can create a count or count statistic value for a numeric column, just not a text column. This was working and has stopped since I updated PowerBI
you can try to use group by function in PQ
https://learn.microsoft.com/en-us/power-query/group-by?wt.mc_id=DP-MVP-5004616
If this still can not solve your issue, pls provide some sample data and expected output.