Forum Discussion

Seabastein's avatar
Seabastein
Frequent Visitor
4 years ago
Solved

Cumulative sum on measure

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

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

     

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.