Hi,
Not sure why my Group By option is giving error. Both data and formula as below:
Regards
Malvika
Hi @MalvikaBhasin ,
The error message shows the type of Profit column is not Number, Please add a step of changing Profit column to Number type before using Sum of Group By step.
Please select one number type you want. I suggest you try whole number firstly.
Best regards,
Mengmeng Li
Hi @MalvikaBhasin ,
The Sum of GroupBy just supports number, your ‘Order ID’ column is text type. Could you please show more details about your requirements about the first GroupBy step?
If you want to show count of table in ‘CountNew’ column, I suggest you use Count Rows in Operation as follows.
Best regards,
Mengmeng Li
Hi,
Below is Group by option that I used, and Group By Error that is generated.
Kindly suggest on how to solve this.
Regards
Malvika
Hi @MalvikaBhasin ,
The error message shows the type of Profit column is not Number, Please add a step of changing Profit column to Number type before using Sum of Group By step.
Please select one number type you want. I suggest you try whole number firstly.
Best regards,
Mengmeng Li
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
