average filtered by categories

[Mariestar]

Hello community 🙂 

I have the following problem when trying to calculate the average, filter by categories and sort by the minimun value: 

What I need 😁 : 

I need to calculate the average departure time for each mission ID.

Filter by mission ID to show only the average for each mission ID

Sort by the minimun value of departure_time so starting from the earliest departure_time 

What I use which doesnt work 😞 : 

CALCULATE(AVERAGE('table'[departure_time], FILTER('table','table'[Mission_ID]=MIN('table'[departure_time]

Any idea on how to solve this issue is much appreciated! 

Regards, 

Marie

[Mariestar]

Thank you @v-yangliu-msft 

It's more complecated than that. I am attaching a photo to show you how my dashboard is. I created the mesure but doesnt fit to my matrice table because I have the days and the mesure is also classed for each day. 

Thank you very much, Pls let me know if you can help me, 

Regards,

Marie

[v-yangliu-msft]

Hi  @Mariestar ,

I created some data:

Here are the steps you can follow：

1. Create measure.

avg_Measure =
AVERAGEX(FILTER(ALL('Table'),
'Table'[Mission_ID]=MAX('Table'[Mission_ID])),[departure_time])

Sort_measure =
RANKX(
    ALL('Table'),[avg_Measure],,ASC,Dense)

2. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly