Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Minimum AVG
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create a measure like

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.