Forum Discussion

Mariestar's avatar
Mariestar
Frequent Visitor
3 years ago

average filtered by categories

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

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Mariestar's avatar
    Mariestar
    Frequent Visitor
    3 years ago

    Thank you Anonymous 

     

    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