SummarizeColumn - Column in table contains a duplicate and is not allowed ...

[Anonymous]

Hi

I'm creating a new table using SummarizeColumn. Here's teh code.

The code below, works fine and I get the table built properly:

SUMMARIZECOLUMNS(
'Transactions'[FullDocumentNumber],
'Transactions'[PersonID],
'Transactions'[PersonName],
Filter('Transactions','Transactions'[Quarter]<>"2021-Q1" && 'Transactions'[Quarter]<>"2021-Q2" && 'Transactions'[Adjustments]="SALES" && 'Transactions'[BONUS]="YES"),

"BookedValue ($)",SUM('Transactions'[BookedValue ($)]),
"SALES",KPIs[Total Sales],
"Total GL Amount", [TotalRevnueGLAmounts],
"Pay or Not", if(
[BookingValue]=0 && KPIs[Total Sales]=0,"NO BONUS","BONUS"),
"Bonus ($)",if([BookingValue]=0 && KPIs[Total Sales]=0,0,0.001*[TotalGLAmounts]))

When I add another column called 'Transactions'[Quarter], I get the error message in the screenshot at end of this post.

SUMMARIZECOLUMNS(
'Transactions'[FullDocumentNumber],
'Transactions'[PersonID],
'Transactions'[PersonName],
'Transactions'[Quarter],     // ===> THIS LINE CAUSES TROUBLES
Filter('Transactions','Transactions'[Quarter]<>"2021-Q1" && 'Transactions'[Quarter]<>"2021-Q2" && 'Transactions'[Adjustments]="SALES" && 'Transactions'[BONUS]="YES"),

"BookedValue ($)",SUM('Transactions'[BookedValue ($)]),
"SALES",KPIs[Total Sales],
"Total GL Amount", [TotalRevnueGLAmounts],
"Pay or Not", if(
[BookingValue]=0 && KPIs[Total Sales]=0,"NO BONUS","BONUS"),
"Bonus ($)",if([BookingValue]=0 && KPIs[Total Sales]=0,0,0.001*[TotalGLAmounts]))

How can I overcome this issue?

[Anonymous]

@bcdobbs Sorryyyyyyyyy Yes IT WORKED!

Thanks a lot

[Anonymous]

@bcdobbs thanks for your prompt response.

There are no relations and still same error message.

[bcdobbs]

The id number that is mentioned in the error message what column does it belong to?

[bcdobbs · Accepted solution]

What relationships do you have to your calculated table? (Power Bi may have added them automatically). Remove any that are there, try your code again and then replace the relationships that you need. When you put the quarters in I suspect yoi start to get duplicates of maybe PersonId which is fine. However powerbi has already set a relationship based on a previous cardinality.