Rearrange the cumulative based on the amount in descending order

[Anonymous]

Hello everyone,

I have a doubt in the calculation of the cumulative percentage (right column).

When I order the rows by the amount the metric stops working because it is created according to the alphabetical order of the customers. This cumulative column would have to add the value of that company plus all the previous ones, reaching the last row with 100%.

Here is the measure I created for the running total:

Running Total=

var sales = CALCULATE (SUM ('table'[Amount]),

                                      FILTER (ALLSELECTED('table'[Customer]), ISONORAFTER ('table'[Customer], MAX ('table'[Customer]), DESC)))

var totalsales = CALCULATE (SUM ('table'[Amount]), ALLSELECTED ('table'))

Return

DIVIDE (sales, totalsales)

Any help is welcome 😀

[Anonymous]

Hi @Anonymous,

Did AlexisOlson's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hello,

I followed this link to resolve it: Cumulative Running Total Based on Highest Value - Excelerator BI

Thanks @AlexisOlson anyway!

[Anonymous]

HI @Anonymous,

Thanks for sharing the solution about your scenario, I think they may help others who faced a similar requirement.😊

Regards,

Xiaoxin Sheng

[AlexisOlson]

If you want it ordered by amount, then use that ordering for the cumulative total.

Running Total =
VAR currAmount = SELECTEDVALUE ( 'table'[Amount] )
VAR sales =
    CALCULATE (
        SUM ( 'table'[Amount] ),
        FILTER ( ALLSELECTED ( 'table' ), 'table'[Amount] >= currAmount )
    )
VAR totalsales =
    CALCULATE ( SUM ( 'table'[Amount] ), ALLSELECTED ( 'table' ) )
RETURN
    DIVIDE ( sales, totalsales )