grant total of time in matrix

[vgangabharani]

I have a table like below:

Date	name	Hours spent
1/1/2010	a	8:00
2/3/2010	a	1:00
3/8/2010	b	10:00
4/10/2010	c	19:00
1/1/2010	a	1:00
6/15/2010	d	20:00

When I load and use a table with name and hours spent I get the below with a having cumulative value of 10:00

name	Hours spent
a	10:00
b	10:00
c	19:00
d	20:00

When I use matrix the sum is wrong. I am using a measure= sum(hours spent) in the matrix. 

name	Date	Hours spent
a		8:00
a	1/1/2010	8:00
a	2/3/2010	1:00
a	1/1/2010	1:00

the grand total is just the first row value. Can someone help me understand this?

[v-frfei-msft · Accepted solution]

Hi @vgangabharani ,

To create a measure as below.

hour = SUMX('Table',HOUR('Table'[Hours spent]))

Pbix as attached.

[v-frfei-msft · Accepted solution]

Hi @vgangabharani ,

To create a measure as below.

hour = SUMX('Table',HOUR('Table'[Hours spent]))

Pbix as attached.

[vgangabharani · Accepted solution]

Thanks for this. I aggregated time like this: 

Measuredummy = If(SUMX(timelog,Minute(timelog[Hours]))>=60,

concatenate(

concatenate(

//hour

SUMX(timelog,HOUR(timelog[Hours]))+quotient(SUMX(timelog,Minute(timelog[Hours])),60), ":"),

//minute

format(mod(SUMX(timelog,Minute(timelog[Hours])),60),"00")),

//else

concatenate(

concatenate(

SUMX(timelog,HOUR(timelog[Hours])),":"),format(SUMX(timelog,Minute(timelog[Hours])),"00")))

[Greg_Deckler]

I cannot recreate this. See Page 7, Table10 of attached.