Forum Discussion

JaderAlexandre's avatar
JaderAlexandre
New Member
4 years ago

Pareto Slow

 

Good Morning, I have one big base, when I try accumulate is very slow.  Someony help me about improve this perfomance in the accumulate ?

 

 Thank you

 

 

mParetoAuditSomentePareto =

var TotalVendas = CALCULATE([VendaTotalPareto],ALLSELECTED(AuditSomenteVendasPareto))
var TotalAtual = [VendaTotalPareto]

var tbResumo = SUMMARIZE(ALLSELECTED(AuditSomenteVendasPareto),CADMER[MERCADORIA],"Total",[VendaTotalPareto])

var TotalAcumulado = SUMX(FILTER(tbResumo,[Total] >= TotalAtual),[Total])

Return DIVIDE(TotalAcumulado,TotalVendas,0)