Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating an average over multiple entries

Hello   The dummy of the data I have is shown below, I am trying to calculate the average project span which would be (20+10+20)/3. However, there are multiple entries for the same project, and when...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could refer to my sample for details. If this is not what you want, please correct me and inform me your expected output.

    Best Regards,
    Zoe Zhi

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

divide(sumx(values(Table[project]), max(Table[Project Span])),distinctCOUNT(Table[project]))

or

avergageX(summarize(Table[project],"_1", max(Table[Project Span])), divide(sum(_1]),count([_1])))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello thanks for replying

I have tried this and it doesn't quite work, I don't think the summation is based on the individual project span. I am trying to figure out how to sum all the project span per project. The distinct count part works but the sum part doesn't.

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    Anonymous 


    Please share an example and provide sample data that we can copy.

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn