cancel
Showing results for
Did you mean:
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.

next to vol column i want to see something like below

LINK TO FILE - TEST- Copy.pbix

appreciate if anyone can help, thanks in advance.

best regards

timur

1 ACCEPTED SOLUTION
Super User

@timurcakin , Try like

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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
4 REPLIES 4
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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Helper I

Hi@amitchandak ,

Volume is measure, shared the link if needed

Super User

@timurcakin , Try like

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

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Helper I

thanks @amitchandak  works like a charm!