Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

need help with running total of cumulative percentage (from measure)

Hi There,


can you please help to calculate the running total of weighted volume % for attached file?


TEST- Copy.pbix


i am trying to find the "running total weighted volume %, its pretty easy to do it on excel, and appearantly not so easy on power bi


itemqtyordervolumvolume %running total weighted volume%
ZUB1379-LED126617477792495.77% 95.77%
ZUB1380-LED42714299883.69% 99.46%
ZUB1378-LED2217638720.48% 99.94%
ZUB137910404000.05%  99.99%
ZUB1378612720.01%  99.99%
ZUB1396850248320.00%  100.00%
ZUB138044160.00%  100.00%



i am not very good at DAX, thanks in advance. 

Super User
Super User

@timurcakin , Create a new measure, assumed volum is a measure


divide([volum], calculate([column], allselected() ) )



There is option on right click of measure to show as % of total




Percent of Total and Percent of SubTotal

!! 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! !!

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors