cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stack23 Regular Visitor
Regular Visitor

Remove Summation on Power BI SQL Server Column

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Remove Summation on Power BI SQL Server Column

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

image.png

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
2 REPLIES 2
Super User
Super User

Re: Remove Summation on Power BI SQL Server Column

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Super User
Super User

Re: Remove Summation on Power BI SQL Server Column

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

image.png

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!