Measure Performance Issue

[adnanarain]

Please see below measure, i am trying to calculate number of customers with 80% sales. I am getting correct result but measure responding very slow almost takes 40 seconds to refresh 3 month data. I am using calculated customer table as i dont have the separate customer table in model.

Customer 80% = 
VAR totalsales = [Sales]
VAR vtable = 
        SUMMARIZE(
        Customer,
        Customer[CustomerN], 
        "vRanking",RANKX(ALLSELECTED(Customer),[Sales],,DESC),
        "vSales",[Sales])
VAR vtable2 = ADDCOLUMNS(vtable,
        "v2CumSales",SUMX(FILTER(vtable,EARLIER([vRanking])>=[vRanking]),[vSales]))
    RETURN 
Countx(
    FILTER(vtable2,[v2CumSales]<=totalsales*0.80),
    [vSales]
)

[amitchandak]

@adnanarain , refer if window function and measure can help

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

[adnanarain]

I treid your soultion but it is also slow and giving error "Visual has Exceed available resources" , I have 29K customers so i want to calculate no of customers who contribute 80% of sales, Sales, cost, profit and profit % for the same. Actually i want the ABC analysis.