Average of Measure (Date and Time)

[colem246]

Hello,

I am very new to Power BI, about a month in, and am in need of some assistance.

I am trying to calculate the average offirst arrivals based on data with the date and timestamp. When I set up a filter for a particular day, all of the information for that day is filtered, but when I add the average measure that I created: Average First Arrival = FORMAT(AVERAGE('Activity First and Last'[First Arrival]) , "HH:MM"), the date filter is being ignored and everything is being averaged.  If I just use AVERAGE('Activity First and Last'[First Arrival])  I get a number with a decimal.

Can someone please advise me on what I could be doing wrong?

[v-ljerr-msft]

Hi @colem246,

If I understand you correctly, you should be able to firstly use the formula below to create a new measure, then use the measure to apply a visual level filter(measure is greater than 0) on the Table visual to get the expected result in your scenario. 

measure = COUNTA ( 'Activity First and Last'[First Arrival] )

Regards

[colem246]

Thank you.

I am actually looking to get the average and not the count. I would want to know what the average first arrival time is for all logon_ids for a particular date.

I use the average(measure) but get the decimal number. I want to get the average in "hh:mm". The formula I am using above is not working. When I use format, it takes the average of everything in the table and ignores the date filter that I have set.

Thanks!

[Greg_Deckler]

Are you using Activity Date for your slicer?

[colem246]

No. The slicer is logon_id

[Greg_Deckler]

Confused, you mention that your date filter is being ignored and you have what looks like a date slicer in your image. Can you share sample data and what you expect for output?

[colem246]

Sorry. The slicer is activity date.

This is how the data looks when I dont add the average measure. I want to ultimately have the average time of all the first arrivals totaled for this particular day (12/24) for all the logon_id that have activity that day.