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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.