DAX question Get company average since last time machine was used

[Anonymous]

Hey Guys, first time posting hopefully this is simple and thank you for taking the time to reply!

Table with Machine ID and all dates/Order numbers it has processed. I added following measure to put in table for last time machine was used

Last Used = CALCULATE(LASTDATE(order[dateordered]),VALUES(order[dateordered]))

Which is returning the most recent date for order ran by that machine ID

Then I added

Days Since Used = DATEDIFF([Last Used],[Today],DAY)

Which shows me it has been X days by machine since that machine has processed.

Now what I want is a new measure that will take a count of the machines and sum Days Since Used and give me a company average of days since machines were last used..

Thanks in advance for the help!

[Greg_Deckler · Accepted solution]

I believe you want something like:

Measure = AVERAGEX(SUMMARIZE('Table',[MachineID],"__days",[Days Since Used]),[__days])

[Anonymous]

Perfect Thanks!