Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 e...
Need Help
  • Ajinkya369's avatar
    Ajinkya369
    6 years ago

    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.

Ajinkya369's avatar
Ajinkya369
Resolver III
6 years ago

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