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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
timurcakin
Helper I
Helper I

weighted average calculation

Hi there,

 

 really struggling to find a solution for this, hope someone can help. 

i am trying to calculate the weigted average of "vol" per item.

 

 

timurcakin_0-1675065740239.png

next to vol column i want to see something like below

 

timurcakin_1-1675065892545.png

 

LINK TO FILE - TEST- Copy.pbix

 

appreciate if anyone can help, thanks in advance.

best regards

timur

 

1 ACCEPTED SOLUTION

@timurcakin , Try like

 

Divide([vol]), Calculate([vol], allselected()) )

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@timurcakin , If volume is column

 

Divide(Sum(Table[VOlume]), Calculate(Sum(Table[VOlume]), allselected()) )

 

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

Hi@amitchandak ,

Volume is measure, shared the link if needed

@timurcakin , Try like

 

Divide([vol]), Calculate([vol], allselected()) )

thanks @amitchandak  works like a charm!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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