Speed Up Cumulative Calculation

[tecumseh]

Hi,

Is it possible to speed up this cumulative calculation?

Cumulative Revenue = 
IF(
ISINSCOPE(Source[Customer]), 
CALCULATE(
[Net_Revenue],
TOPN([Rank],
ALLSELECTED(Source[Customer]),
[Net_Revenue])
),
[Total Net Revenue]
)

 Thanks,

-w

[tecumseh]

Thanks @AlexisOlson ,

That solved it perfectly!

Thanks,
-w

[AlexisOlson · Accepted solution]

See if this helps:

Cumulative Revenue =
VAR _Rank = [Rank]
VAR _CustRev_ =
    ADDCOLUMNS (
        ALLSELECTED ( Source[Customer] ),
        "@NetRev", [Net_Revenue]
    )
VAR _TopNRev =
    SUMX (
        TOPN ( _Rank, _CustRev_, [@NetRev] ),
        [@NetRev]
    )
RETURN
    IF (
        ISINSCOPE ( Source[Customer] ),
        _TopNRev,
        [Total Net Revenue]
    )