Cumulative sum on measure

[Seabastein]

Hello,

I need your help because I am struggling with a cumulative sum that isn't linked to a date.

I have a visual that looks like this:

And I want to achieve what I wrote in the column 1.

For example, the formula for the % of the total is this:

I have seen some formulas containing the dates as a way to sort, but the dates are linked with individual sales. So I don't know how to pull this off.
Thanks in advance
Sebastien

[v-chenwuz-msft · Accepted solution]

Hi @Seabastein ,

You can use sales as index to calculate cumulative sum. Please refer this:

cumulative sum = 

VAR _s =
    SUMMARIZE (
        ALLSELECTED ( data ),
        [customer name],
        "_sales", SUM ( data[sales] ),
        "%", [ % of total]
    )
RETURN
    SUMX ( FILTER ( _s, [_sales] <= SUM ( data[sales] ) ), [%] )

Best Regards

Community Support Team _ chenwu zhu

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

[CNENFRNL]

Your case is an simplified variant of Pareto analysis. There are countless examples on the forum or on the internet.