topic Re: Calculate Cumulative % Of Totals without date in DAX Commands and Tips

Calculate Cumulative % Of Totals without date

Anonymous — Tue, 05 Mar 2024 16:13:08 GMT

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%

Re: Calculate Cumulative % Of Totals without date

JamesFR06 — Tue, 05 Mar 2024 16:44:43 GMT

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)

Re: Calculate Cumulative % Of Totals without date

Anonymous — Wed, 06 Mar 2024 07:51:49 GMT

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.

Re: Calculate Cumulative % Of Totals without date

Anonymous — Wed, 06 Mar 2024 14:50:11 GMT

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