Table sum total incorrect

[Kaushik2020]

Hi all, I am using QS Server version - 14.78.0 

the sum of table count is not correct. 

[Aurelien_Martinez · Accepted solution]

Hi,

Can you share your expression?

I can try to change the total function in your measure.

[Kaushik2020]

thanks for the information. it was set to default. I changed to Sum as per your suggestion and it's working fine now. 

Do you know why with Auto - it was calculating incorrectly Or what happens in the background. 

coz other columns were calculating correctly. 

[Aurelien_Martinez · Accepted solution]

It's depending of your expression. For example if you have a Count(distinct ID) :

The expression is evaluate on each row, with my data :

Level 1 : ID=1, ID=2 => 2

Level 2: ID=1 => 1

Total : ID=1, ID=2 >=2

[Kaushik2020]

thanks a lot for the explanation 🙂