Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

CMaxted98

Sort by total error in matrix

Submitted by on ‎04-28-2023 07:48 AM

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

CMaxted98_0-1682693238843.png

 

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/

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎05-01-2023 01:49 AM

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
New Member
‎05-02-2023 06:29 AM

Hi @Anonymous 

 

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

CMaxted98_1-1683034101866.png

 

Idea Statuses