Power Query: DISTINCT COUNT in GROUP BY on table not working

[Anonymous]

Hi guys, 

i want to group a table in power query by the column "DIM_ID_ARTIKELGROESSE". I want to summarize the other columns with "Count Rows" or "Count distinct rows".

My problem is that i can not select any of the columns i want to summarize in the drop down next to Opertion. 

However if select a different Operation such as "Min" i can select the other columns:

Thanks for any tips!

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

As far as I know, "Count Rows" or "Count distinct rows" should distinct count all other rows grouped by "DIM_ID_ARTIKELGROESSE".

So when the Group by function selects Count-related operations, Column will not display columns, but will directly affect all rows. When operations such as SUM, AVG, etc. are selected, they will be displayed.

For reference: Grouping or summarizing rows

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.