Sort by total error in matrix

[CMaxted98]

Power BI will let me sort by first column but not total at the end of the matrix table

Error:

Query (45, 3) Function 'SUMMARIZECOLUMNS' cannot add column [Product] since it already exists.

Activity ID: aa326b55-3626-49a9-b8b9-f98f6e61fca4
Request ID: acb1da95-3169-4ae2-80f6-4761aef24e1f
Correlation ID: dd0ed4ac-edc1-7469-3e0c-800f4f6ae584
Time: Fri Apr 28 2023 15:39:56 GMT+0100 (British Summer Time)
Service version: 13.0.20534.70
Client version: 2304.3.13501-train
Cluster URI: https://wabi-north-europe-l-primary-redirect.analysis.windows.net/

[Anonymous]

Hi @CMaxted98 

What operation is causing this error to be reported ? Can you describe this operation in detail ?

Best Regards,
Community Support Team _ Ailsa Tao

[CMaxted98]

Hi @Anonymous 

I am using a matrix table, when looking to sort by total the error appears: