Summarization NOT WORKING

Question

I have a table with values from a SQL Database. I want the columns to Sum the values. I have SUM selected in the Summarization but the sigma does not show up and I can't build visualizations.

anonymous · Answer

HI&nbsp;Anonymous&nbsp;&nbsp;You have to chage the data type to whole number ot integer.&nbsp;

anonymous · Answer

No that's not it. I get options for latitude and longitude. I changed both to Whole number and I got an option for a bar code or postal code.&nbsp;&nbsp;&nbsp;

anonymous · Answer

I have a similar report that I copied some queries from where the summarizations are working without a Data Category.&nbsp;

anonymous · Answer

HI&nbsp;Anonymous&nbsp;,
&nbsp;
&nbsp;
Go to model View and change the Default Summarization.
&nbsp;
Also, check for the Data Type in Power Query.
&nbsp;

&nbsp;
&nbsp;
Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

v-xicai · Answer

Hi,
&nbsp;
You may create calculated column or measure like DAX below.
&nbsp;
SumTotal_Column = SUM('Table1'[Column2])

SumTotal_Measure = CALCULATE(SUM(Table1[Column2]), ALL(Table1))
&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.