Remove Summation on Power BI SQL Server Column

[stack23]

How do I remove a summation property for a Power BI SQL table? I have a Customer Transaction Table. For some reason PowerBI is trying to Measure Sum the CustomerTransactionId primary key row. I do not want this added. Please see picture below.
I just want to display all rows in a table.

CREATE TABLE [dbo].[CustomerTransaction]
(
[Customertransactionid] [int] IDENTITY(1,1) primary key NOT NULL,
[Customerid] [int] NULL,
[Quantitybought] [int] NULL,
)

 

[1]: https://i.stack.imgur.com/qg0A1.png

[TomMartens · Accepted solution]

Hey,

if you can change the default aggregation function used for numeric columns, this will work either in connections to SQL Server tables in "direct query" or "import" mode.

Mark the column and in the Modeling menu you can change the "Default summerization" for the column to: Don't summarize

Please be aware that is a limit of 1 MIllion rows that can be returned by a query utilizing a connection in "Direct query" mode.

Maybe you might consider to change the summerization to "Count".

Regards,

Tom

[Greg_Deckler]

In the Values area, click the drop down next to the column in question. Choose "Do not summarize". Or you can change th default aggregation method in the model.