Performance of running in total by ranking

[tannhq]

Hello everybody,

I create a measure Running in total by [Total Sales] ranking, in order to know top customers by % of sales. 

But the performance is so slow.  Can anyone have the idea or solution for this.

There are 2 measures that I'm using: 

Customer RANK =
IF (
    [Total Sales] > 0,
    IF (
        ISINSCOPE ( Customers[Code-Customer] ),
        RANKX (
            FILTER (
                ALLSELECTED ( Customers[Code-Customer] ),
                [Total Sales] > 0
            ),
            [Total Sales]
        )
    )
)

Total Sales Running In Total = 
VAR CurrentRank = [Customer RANK]
VAR SummaryCustomers =
    CALCULATETABLE (
        VALUES ( Customers[Code-Customer] ),
        FILTER ( ALLSELECTED ( Customers[Code-Customer] ), [Total Sales] > 0 )
    )
VAR CustomerAndRank =
    ADDCOLUMNS (
        SummaryCustomers,
        "@Sales", [Total Sales],
        "@Rank", [Customer RANK]
    )
VAR Result =
    SUMX ( FILTER ( CustomerAndRank, [@Rank] <= CurrentRank ), [@Sales] )
RETURN
    Result

Thanks very much.

[amitchandak]

@tannhq , Try like

Customer RANK =
RANKX (
FILTER (
ALLSELECTED ( Customers[Code-Customer] ),
[Total Sales] > 0
),
[Total Sales]
)

Total Sales Running In Total =
VAR CurrentRank = [Customer RANK]
VAR CustomerAndRank =
ADDCOLUMNS (filter( Sumamrize(Customers, Customers[Code-Customer] ),[Total Sales] > 0 )
SummaryCustomers,
"@Sales", [Total Sales],
"@Rank", [Customer RANK]
)
VAR Result =
SUMX ( FILTER ( CustomerAndRank, [@Rank] <= CurrentRank ), [@Sales] )
RETURN
Result

Also refer

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

[tannhq]

Thanks @amitchandak , 

Your measure return the same number of total sales.

I try to add ALL (or ALLSELECTED)  and the performance still is so slow.