Accumulated percentage.

[jacyquadros]

Hello I have a problem in a cumulative percentage calculation. For example:

January:

Value   -    Quantity   -    %            -   Accumulated

 100     -           3           -   33.33%  -   33.33%

February:

Value   -     Quantity   -    %             - Accumulated

   90      -           6           -   15%         - 21.11%

Calculation of % is (value / Quantity)

The value of 48.33% is the value that should appear in the graph (33.33% + 15%), but the accumulated percentage is presented as 21.11%, since it sums the total value and divides the total quantity.

I need you to just add the percentage, could you help me?

[v-xicai]

Hi jacyquadros ,

According to your description, I create sample data to test the scenario.

Firstly, create column Month_Num to get month number for further analysis, and create measure Accumulated % to get accumulated percentage.

Month_Num = SWITCH(Table1[Month],"January",1,"February",2,"March",3,"April",4,"May",5,"June",6,"July",7,"August",8,"September",9,"October",10,"November",11,"December",12)

Accumulated % = CALCULATE(SUM(Table1[%]),FILTER(ALL(Table1),Table1[Month_Num]<=MAX(Table1[Month_Num])))

Choose table visual to display the result.

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWlL7Vj50dhKpgVhCG...

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jacyquadros]

Hello, first I thank you for you help.

The problem is that, I don't have the colunm '%', I have only the value and the Quantity, so I divide the value for Quantity, for example:

sum(value)/sum(quantity)

So the % will be calculate by as I show in the question, wil be, the total value <= mounth and the total quantity<= mounth, so wil be a % diferent .
You understood?
Thank you.