Calculate Cumulative % Of Totals without date

[Anonymous]

Im trying to get a calculation of the cumulative % of totals.

Example i have the values by names (and no date order cause i filter with a slicer by year and month) in this case im more interested in obtaining the total per name, and sorted them by value from higher to lower. but i cant manage to get the cumultive %

Name	Value	%	Cumulative
A	1739	35.8%	35.8%
B	1094	22.6%	58.4%
C	784	16.2%	74.6%
D	775	16.0%	90.5%
E	245	5.1%	95.6%
F	194	4.0%	99.6%
G	20	0.4%	100.0%
Total	4851	100.0%

[Anonymous]

Hello! I tried this and im getting close to it, however although im sorting the table by Value, the calculation for the cumulative value ranks the accumulative sum by the store name rather than the highes value, so im getting very random % along the accumulative column: this is the code i used 

CumulativeTotal = 

VAR CurrentStore = SELECTEDVALUE([Store])

VAR TotalSales = CALCULATE(SUM([Value]), ALLSELECTED([Store]))

VAR CumulativeSales = SUMX( 

    FILTER( 

        ALL([Store]), 

        [Store] <= CurrentStore 

    ), 

    CALCULATE(SUM([Value])) 

) 

RETURN DIVIDE(CumulativeSales, TotalSales

[v-yohua-msft]

Hi, @Anonymous 

Maybe you can also try the following DAX:

Cumulative total = 
CALCULATE(
    SUM('Table1'[Value]),
    FILTER(
        ALLSELECTED('Table1'),
        'Table1'[Name] <= MAX('Table1'[Name])
    )
) / CALCULATE(SUM('Table1'[Value]), ALL('Table1'))

Here is my preview:

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

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

[JamesFR06]

Hi Carferrom

I have create a table "Cumulative" with your datas.

Please find the code of the measure :

CumulativeTotal =

var ventes =sum(Cumulative[Value])

var TotalSales=calculate(sum(Cumulative[Value]),all(Cumulative))

var ProgCumul=

sumx(

filter(summarize(allselected(Cumulative),Cumulative[Name],

"Ventes Periode",sum(Cumulative[Value])),

[Ventes Periode]>=ventes),

[Ventes Periode])

return

divide(ProgCumul,TotalSales)