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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
753 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
740 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
727 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
741 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
732 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
728 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
742 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All