How to find the average time per job id in power bi?

Question

I need to find the average time per job id.

Below is the data

I tried this dax query

AverageTime =
AVERAGEX (
    VALUES ( Ratings[Date] ),
    CALCULATE ( AVERAGE ( Ratings[job_id] ) )
)

Data type of Date is Time

Answer 1

1. To calculate the average time per job_id, create a calculated column with the following DAX formula:

    Average Date = 
    var jo_id = 'Table'[job_ID]
   
   Return
   AVERAGEX( 
       FILTER(ALL('Table'), 'Table'[job_ID] = jo_id),
             'Table'[Date])
   

2. After creating the Average Date column set the data type to Time in the Column tools, and set the format as desired.

You should have the desired result.

Answer 2

I have obtain the result using the following formula, should be correct as you expected. Calculate method is not necessary since the table will filter the value base on id, :

= FORMAT(AVERAGE(Sheet2[date]),"HH:MM:SS")