Calculating Averages

[ch2222]

Hi,

I am trying to calculate average hours for the items below, however I need to base my average on 4 containers. Thank you!

[v-stephen-msft]

Hi @ch2222 ,

Is your problem solved?

If so, please accept the reply as solution, more people will benefit.

If not, please provide me with more details about your problem.

Best Regards, 

Stephen Tao

[v-stephen-msft]

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.