Forum Discussion

ch2222's avatar
ch2222
New Member
3 years ago

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!

 

 

Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.           

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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