Query editor group by will not count rows to create an Agg table

Question

i am in query editor trying to use the group by function to create a Agg table but when i choose count rows it will not let me pick a column .&nbsp; &nbsp;&nbsp;

v-yuta-msft · Answer

Anonymous&nbsp;,
&nbsp;
Because there's no need to select a column when you select "Count Rows". The result is not related to the specific colums.
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

anonymous · Answer

&nbsp;Anonymous&nbsp;wrote:They are saying that the column that you select is irrelevant because it will be the same amount of rows no matter what column you choose.even if its countdistinct rows?

hotchilli · Answer

That's the default behaviour.&nbsp; It has all the information it needs.&nbsp;&nbsp;

anonymous · Answer

Can you explain a bit more.. i am not following

anonymous · Answer

They are saying that the column that you select is irrelevant because it will be the same amount of rows no matter what column you choose.

Forum Discussion

Query editor group by will not count rows to create an Agg table

6 Replies

Related content

power query editor slow loading

Creating dim table in Query editor

Abnormal data display in Query Editor

Power Query Editor cannot be used

Power Query Editor