Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Summarization NOT WORKING

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.    ...
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

You may create calculated column or measure like DAX below.

 

SumTotal_Column = SUM('Table1'[Column2])



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

 

 

 

 

 

 

Best Regards,

Amy 

 

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.