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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.