Calculate Minimum Average after column value

[Anonymous]

Hi all, 

I' am doing a sport analysis in which i need to calculate an average of best efforts in specific sports drills. 

So, I'm looking towards caluating a average of minimum time spend on a drill after player_name.

=

Player_name	Total_time	Minimum_time	Avg ((10+30)/2)
X x	10	10	20
X x	20	10	20
X x	30	10	20
Y y	30	30	20
Y y	40	30	20
Y y	50	30	20

Cheers, 

/M

[mahoneypat · Accepted solution]

Please try this expression in your measure in a table visual with Player_Name (and any other columns).

Avg Time =
AVERAGEX (
    ALL ( Times[Player_name] ),
    CALCULATE (
        MIN ( Times[Total_time] ),
        ALLEXCEPT (
            Times,
            Times[Player_name]
        )
    )
)

Regards,

Pat

[Anonymous]

Absolute legend @mahoneypat , thx!

//M

[amitchandak]

@Anonymous , Create a measure like

averageX(values(Table[Player_name]), calculate(Min(Table[Total_time])))

[Anonymous]

Hi,

Thanks for the effort! 🙂

That doesn't return a single AVG. The AVG varies row for row. It should be the same for the whole table as the AVG should be calculated for the whole table meaning AVG of minimum-time after player = Óne value for all rows, as they are subject to the same table avg.