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! Learn more

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
693 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
680 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
667 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
681 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
672 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
668 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
682 Views
0

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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