Forum Discussion
Column not summarized
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
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.
9 Replies
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 🙂
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
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?
Hi Guys,
this is the shortcut to my file, Please help me on the column 'Cooling tower' why doesnt it sum up.
My measures is with brackets and data type is number too.
Thanks and Regards,
VanCe
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!
