Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 drill after player_name.

=

Player_nameTotal_timeMinimum_timeAvg ((10+30)/2)
X x101020
X x201020
X x301020

Y y

303020
Y y403020
Y y503020

 

 

Cheers, 


/M

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Anonymous
Not applicable

Absolute legend @mahoneypat , thx!

 

//M

amitchandak
Super User
Super User

@Anonymous , Create a measure like

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.