topic Calculate Minimum Average after column value in DAX Commands and Tips

Calculate Minimum Average after column value

Anonymous — Wed, 28 Oct 2020 13:45:22 GMT

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,

Re: Calculate Minimum Average after column value

amitchandak — Wed, 28 Oct 2020 15:20:48 GMT

Anonymous , Create a measure like

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

Re: Calculate Minimum Average after column value

Anonymous — Wed, 28 Oct 2020 15:34:11 GMT

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.

Re: Calculate Minimum Average after column value

mahoneypat — Wed, 28 Oct 2020 23:54:37 GMT

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

Re: Calculate Minimum Average after column value

Anonymous — Thu, 29 Oct 2020 12:33:12 GMT

Absolute legend mahoneypat , thx!

//M