cancel
Showing results for
Did you mean:
Helper I

## Running sum % help needed (from calculate)

Hello,

I am not very good at dax but need this for my work so appreciate if you can help with the request.

TEST- Copy.pbix

i am trying to find the "running total weighted volume %, its pretty easy to do it on excel,

unfortunately data coming from measure so it makes calculation harder.

 item qty order volum volume % running total weighted volume% ZUB1379-LED 126 6174 777924 95.77% 95.77% ZUB1380-LED 42 714 29988 3.69% 99.46% ZUB1378-LED 22 176 3872 0.48% 99.94% ZUB1379 10 40 400 0.05% 99.99% ZUB1378 6 12 72 0.01% 99.99% ZUB13968502 4 8 32 0.00% 100.00% ZUB1380 4 4 16 0.00% 100.00%

timur

1 ACCEPTED SOLUTION
Community Support

Hi @timurcakin ,

The last formula I gave was to accumulate in descending order by [No_], I have since realised that you may want to accumulate in descending order by [Order], please try this measure.

``````running total weighted volume% =
VAR _order = [order]
VAR _result = SUMX(FILTER(SUMMARIZE(ALLSELECTED('Sheet3'),'Sheet3'[No_],"OD",[order]),[OD]>=_order),[weighted vol %])
RETURN
_result``````

Best Regards,
Gao

Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

6 REPLIES 6
Community Support

Hi @timurcakin ,

``running total weighted volume% = SUMX(FILTER(ALLSELECTED('Sheet3'[No_]),'Sheet3'[No_]<=SELECTEDVALUE('Sheet3'[No_])),[weighted vol %])``

Best Regards,
Gao

Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helper I

Hello Gao,

sorry for the late reply i was away.

i think the formula you have provided is taking the running total of weigted vol by sorting out items, not weigted volumes. 😞

Community Support

Hi @timurcakin ,

The last formula I gave was to accumulate in descending order by [No_], I have since realised that you may want to accumulate in descending order by [Order], please try this measure.

``````running total weighted volume% =
VAR _order = [order]
VAR _result = SUMX(FILTER(SUMMARIZE(ALLSELECTED('Sheet3'),'Sheet3'[No_],"OD",[order]),[OD]>=_order),[weighted vol %])
RETURN
_result``````

Best Regards,
Gao

Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helper I

Hey Gao,

AMAZING thank you soooo much for this!

Seems very complex (for me :)) but you managed to sort it out  so thank you very much for helping me.

all the best!

Super User

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper I

Hi Greg,

if i understand correctly your calculations are coming from a table whereas my numbers are part of a measure