Average from measure with Datediff

[Gazsim44]

Hi All, 

I have a measure which I am using to calculate the hours an employee is on site by using the first and last times they are utilising the access control system.

Hours Present = DATEDIFF(MIN('Access Report'[Date/time]),MAX('Access Report'[Date/time]),MINUTE)/60

However we now need to calculate the average hours present on any given day of the week based on the employees selected / and / or month / date etc. (using slicers as filters). 

A sample of my table is attached.

Thanks

[v-lili6-msft]

hi  @Gazsim44 

here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/convert-measures-to-column-for-correct-average/m-p/1145598

If you still have the problem, please share your sample pbix file and your expected output.

Regards,

Lin

[Gazsim44]

Hi, I've found that this solution from @Greg_Deckler  has successfully managed what I needed.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

The issue was initially in the totals not calculating correctly so once resolved obtaining the average was relatively easy!

Thanks, 

[v-lili6-msft · Accepted solution]

hi  @Gazsim44 

It's pleasant that your problem has been solved, 😁

For measure totals problem. it is a common problem, there is another blog for you refer to: 
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

please accept my reply as answer, that way, other community members would easily find the solution when they get same issues.

Regards,

Lin

[amitchandak]

@Gazsim44 , refer to my blog on this. You need to give correct row context using summarize or values

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...