Forum Discussion

adnanarain's avatar
adnanarain
Helper V
3 years ago

Measure Performance Issue

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]
)

 

 

Need Help

2 Replies

    • adnanarain's avatar
      adnanarain
      Helper V
      3 years ago

      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.