Column not summarized

[Anonymous]

Hi,

I would like to ask why the column does not summarize even tho its selected as 'Sum' already. the format is also number, when dragged into the values space, it only shows the very first day of each month's value.

Even i create a measure like e.g.

SumCT = sum(table, column)

it does not work too. Please help.

Thanks and Regards,

VanCe

[v-diye-msft]

Hi @Anonymous 

If the above post helps, please kindly mark it as answer to help others find it more quickly. If not, please kindly elaborate mroe. thanks!

[amitchandak]

@Anonymous , check its data type

Sum(Table[Column])

sumx(Table,Table[column]) should work

Can you share sample data and sample output in table format?

[Anonymous]

Hi Guys,

this is the shortcut to my file, Please help me on the column 'Cooling tower' why doesnt it sum up.

https://hkland-my.sharepoint.com/:u:/p/zhide_goh/ET3eA_DwUO1JuTa7uAzGQfIB32F9AB7tPqRuRHYOoq8dRg?e=pN...

My measures is with brackets and data type is number too.

Thanks and Regards,

VanCe

[Anonymous]

Hi,

Anyone able to help me? Is it bugged?

Thanks an Regards,

Zhide

[Ajinkya369 · Accepted solution]

Hey @Anonymous ,

The date which you are using in the matrix/table(calender dimension table);It contains first day of each month.

This is your date dimension table.

It gives all date when you select the date from anacle table instead of calender dimension table.

desired result,when you select date from the anacle table.

If your problem is solved please accept this as solution.

Thank you.

[Anonymous]

Hi Ajinkya,

Thanks for replying, for the date field in anacle column, i do not have a hierachy, i wanted to be able to sort it in years and months, do i have to create new columns? But that defeats the purpose of having the calendar table isnt it?

I do not want the calendar table dates to be just first day of each month, i input it as 1 Jan in excel data table because i cant remove the 1st to represent the whole month, how do i make it have all range?

Thanks and Regards,

VanCe

[Ajinkya369]

Hey @Anonymous ,

I have opened your file please tell me on which report page you are facing problem?

You can connect me through remote desktop also.I will share your the credentials in the personal message.

Thank you

[Ajinkya369]

hey @Anonymous ,

Please correct the formula:

SumCT=sum(Tablename[Column name])

Column name should be covered with square brackets.

You can use something like this also:

SumCT=Calculate(Sum(Tablename[column Name])

I'm attaching below the solved screenshots for your problem.

Measure

Table visual where date and Sumct measure is used

If your problem is solved then please accept this as solution.

Thank you

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn