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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Abishek
Helper I
Helper I

Weighted Average - Large Dataset

Hi,
I am new to power BI. 

 

Is “Summarize Table” a good option for a large data set approx(60 million rows)?

Reason why I need this functionality is that I use "Weighted average" for all my Aggregation and Group By throughout all visuals,

 

“No default aggregation to be applied while using visuals ”.
All the visuals should use weighted average and have to change based on filter/slicers 


Can someone please help in choosing the right approach to solve this problem. Because this is a very important functionality.   ?

1 REPLY 1
amitchandak
Super User
Super User

@Abishek , You formula should avoid row calculation. You should have measure like

 

Divide(Sum(Table[A]) , Sum(Table[B]))

or

 

Divide(Sum(Table[A]) , count(Table[A]))

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric 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.

Users online (25)