Forum Discussion
Calculate Minimum Average after column value
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...
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
mahoneypat
Microsoft Employee
Microsoft EmployeePlease 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