Forum Discussion
Automatic GroupBy while summation
Hi Sparsh98 ,
The fields in the form/matrix will auto-groupby. it's by design.
The workaround is to add an index column (in powerquery) and disguise it as a row number.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
You don't want to aggregate? Is that it?
No , I want to do sum on column Value . Post doing sum , it is combining rows 1 and 2 , and I am getting combined sum as 4 for Name 'a' . Thats is what I want to prevent as it is impacting the number of rows in my case .
I want to do sum on column Values , but the number of rows should not get altered