Sum function error

[sirros_iot]

Hello All!
Well, I have this table..

Until here everything was Ok, but when I change the column [intervalo] to return me a Sum...

It returns me a value 5 or 4 times higher.... What can do it? And there's is only a day difference!
Any idea...

Thanks,
Diego

[Phil_Seamark · Accepted solution]

Hi @sirros_iot

it means you have more data in your data-table that you think.  I suspect you have multiple rows that have a contagem = 93

Add the following measure to your table visual to check

debug measure = COUNTROWS(<yourtablenamehere>)

and drag that to your visual.  I bet it returns a number higher than 1

[sirros_iot]

Hi @Phil_Seamark, you were right!

Do you know a way of calculating it just with one value?
Obs: I'm connected by direct query.

Thanks, 
Diego