Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AMSto
Regular Visitor

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 I try to use the normal average in the visuals, the number is incorrectly calculated. I have attempted to use the measure averagex(summarise... but this also does not work. 

 

In summary, how do I calculate the average over one column, when the value may be repeated multiple times in the column for different rows. 

I am still new to PowerBi so struggling to get to grips with everything. 

thanks

AMSto_0-1596618130209.png

 

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi @AMSto , 

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.

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.