Sum of max values then average

[Anonymous]

Hi everyone 

I'm looking for a formula to calculate the sum of max values and then average it by the number of distinct values in the job number column

eg: I have a table with job numbers and lead times. I need a formula to calculate (5+10+15)/3 = 10

job number	lead time
x	5
x	5
x	5
y	10
y	10
z	15

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You also could create measure as follows:

Measure = AVERAGEX(SUMMARIZE('Table',[job number],[lead time]),[lead time])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try measure like

AverageX(values(Table[Job Number]), calculate(Max(Table[Lead Time])) )