Average of Measure (Time data)

Hi LakiCG,

Based on my test, you can refer to below steps:

1.I have entered some sample data to test your problem, here is the data I entered in below picture.

2.I create two measures you mentioned in your problem and create two new measures to calculate the average time of the First Call and the Last Call.

First Call = CALCULATE(MIN('Calls'[Local Time]),Calls[direction]="Outbound")

Last Call = CALCULATE(MAX('Calls'[Local Time]),Calls[direction]="Outbound")

Avg First call = var a=SUMMARIZE('Calls',[Date],"firstcall",CALCULATE(MIN('Calls'[Local Time]),Calls[direction]="Outbound"),"Lastcall",CALCULATE(MAX('Calls'[Local Time]),Calls[direction]="Outbound"))

return FORMAT(AVERAGEX(a,[firstcall]),"h:mm:ss")

Avg Last call = var a=SUMMARIZE('Calls',[Date],"firstcall",CALCULATE(MIN('Calls'[Local Time]),Calls[direction]="Outbound"),"Lastcall",CALCULATE(MAX('Calls'[Local Time]),Calls[direction]="Outbound"))

return FORMAT(AVERAGEX(a,[Lastcall]),"h:mm:ss")

3.Create a Table visual, add the [Data], [First Call], [Last Call]. Create a Card visual, add the [Avg Last call] and [Avg First Call] fields. Now you can see the result.

You can also download the PBIX file to have a view.

 https://www.dropbox.com/s/z7hb9ovfa0zwjwh/Average%20of%20Measure%20%28Time%20data%29%20.pbix?dl=0

Regards,

Daniel He