Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
rainchong7401
Helper III
Helper III

How to Calculate Average of Total

‎10-26-2022 02:14 AM

Hi Guys,
I use this formula to calculate average.
It looks fine for each lines.
But when comes to total.
It reflect in "Total for AVERAGE PREVIOUS MONTHLY SOLD" column as summing all averages instead of Average it properly.
I need help. 

200k+ average doesnt make sense.
If below 80 make more sense and look fine.

rainchong7401_0-1666775377992.png

 

Labels:
Message 1 of 5
402 Views
0
2 ACCEPTED SOLUTIONS
VijayP
Super User
Super User

‎10-26-2022 02:24 AM

@rainchong7401 Try following this!

VijayP_0-1666776255894.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

Message 3 of 5
389 Views
VijayP
Super User
Super User
In response to rainchong7401

‎10-26-2022 02:43 AM

@rainchong7401 You are welcome!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

Message 5 of 5
376 Views
4 REPLIES 4
VijayP
Super User
Super User

‎10-26-2022 02:24 AM

@rainchong7401 Try following this!

VijayP_0-1666776255894.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Message 3 of 5
390 Views
rainchong7401
Helper III
Helper III
In response to VijayP

‎10-26-2022 02:36 AM

Hi Vijay,
You're such a life saver & time saver.
really appreaciated 

Message 4 of 5
381 Views
0
VijayP
Super User
Super User
In response to rainchong7401

‎10-26-2022 02:43 AM

@rainchong7401 You are welcome!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Message 5 of 5
377 Views
mangaus1111
Solution Sage
Solution Sage

‎10-26-2022 02:20 AM

Hi @rainchong7401 ,

please send sample data source and your expected result.

 

For worng totals in visual I recommend to see this video

https://www.youtube.com/watch?v=6rgAkejrup8 

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

Message 2 of 5
391 Views
0

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.

View All