Forum Discussion
Calculating Averages
Hi, I am trying to calculate average hours for the items below, however I need to base my average on 4 containers. Thank you!
Hi ch2222 ,
What's the meaning of containers? Please display the expected results.
For now, you can try AVERAGE function.
AVERAGE function (DAX) - DAX | Microsoft Learn
If you also want the average values grouped by a certain field, please refer to
Measure = CALCULATE(AVERAGE('Table'[Net_Hrs]),FILTER(ALLSELECTED('Table'),[Name]=MAX('Table'[Name])))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.