Challenge to find total and avg time

[Anonymous]

Dear Experts,

Kindly help me to find the total and avg time for each engineer against the tickerts raised in a day.Also need to find the total working hours  in day against the std working of 9 hrs.

Date	Engineer Name	User Name	Reported Issues	Time Taken to resolve the issue minutes
25-Nov-20	Eng 1	Usr 1	Issue A	20
25-Nov-20	Eng 1	Usr 2	Issue B	5
25-Nov-20	Eng 1	Usr 3	Issue C	60
26-Nov-20	Eng 1	Usr 1	Issue A	5
27-Nov-20	Eng 1	Usr 2	Issue C	15
25-Nov-20	Eng 2	Usr 1	Issue A	15
25-Nov-20	Eng 2	Usr 2	Issue B	20
25-Nov-20	Eng 2	Usr 3	Issue C	20
26-Nov-20	Eng 2	Usr 1	Issue A	10
27-Nov-20	Eng 3	Usr 2	Issue C	10
25-Nov-20	Eng 3	Usr 1	Issue A	10
25-Nov-20	Eng 3	Usr 2	Issue B	10
25-Nov-20	Eng 3	Usr 3	Issue C	5
26-Nov-20	Eng 3	Usr 1	Issue A	10
27-Nov-20	Eng 3	Usr 2	Issue C	10
25-Nov-20	Eng 4	Usr 1	Issue A	45
25-Nov-20	Eng 4	Usr 2	Issue B	20
25-Nov-20	Eng 4	Usr 3	Issue C	20
26-Nov-20	Eng 4	Usr 1	Issue A	10
27-Nov-20	Eng 4	Usr 2	Issue C	10
25-Nov-20	Eng 5	Usr 1	Issue A	45
25-Nov-20	Eng 5	Usr 2	Issue B	20
25-Nov-20	Eng 5	Usr 3	Issue C	20
26-Nov-20	Eng 5	Usr 1	Issue A	20
27-Nov-20	Eng 5	Usr 2	Issue C	20

[v-xulin-mstf]

Hi @Anonymous,

Try measures as:

Total hours = 
CALCULATE(
    SUM('Table'[Time Taken to resolve the issue minutes])/60,
    FILTER(
        ALL('Table'),
        'Table'[Engineer Name]=MAX('Table'[Engineer Name])
    )
) 

Average hours = 
CALCULATE(
    AVERAGE('Table'[Time Taken to resolve the issue minutes])/60,
    FILTER(
        ALL('Table'),
        'Table'[Engineer Name]=MAX('Table'[Engineer Name]) 
    )
) 

Here is the output:

Here is the demo, please try it.

Best Regards,

Link

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

[amitchandak · Accepted solution]

@Anonymous , Is not

AverageTable[Time Taken to resolve])

and

Sum(Table[Time Taken to resolve])

should help

what is expected output

[Anonymous]

Thanks @amitchandak ,

Yes i have done it.However i need this time(mins) to be convereted in hrs.From this hrs i need to understand total hrs of each engineer in month & date against the standard working hrs of 9hrs /day.