Total of column

[zsodf]

Hello, 

I created a measure "SpendTime" and when I display the table , total of SpendTime is false and I dont know why .

I tried to create a new measure to sum "SpendTime" but doesn't  work because I think we can't not sum a measure 

So I need help please 

[amitchandak]

@zsodf , Try a measure like

Sum time =
var _time = sumx(Time1,HOUR(Time1[_spendTime])*3600+Minute(Time1[_spendTime])*60 +SECOND(Time1[_spendTime]))
return
time(QUOTIENT(_time,3600) ,QUOTIENT(Mod(_time,3600),60),mod(Mod(_time,3600),60))

[zsodf]

@amitchandak , I tried but I have the same problem 

[v-yueyunzh-msft]

Hi, @zsodf 

According to your description, your Total presents data that is not a sum, and calculating total in measure is calculated according to the current filtering context rather than a simple sum.

There are two ways to modify total:

(1)Modify the measurement writing method and use functions such as HASONEVALUE() or SUMX().

(2)Use New Column, and the column is placed inside the visual.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly