Forum Discussion
Solved
Automatic GroupBy while summation
Hi PowerBI Community, I am facing an issue where while doing summation of a column it is automatically summing after grouping the data For example if input data is On doing Sum , output I...
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
