cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mimi Regular Visitor
Regular Visitor

Cumulative Total Formula is very Slow

Hi

 

The formula of Running Total or Cumulative Total that is inserted in measures is very slow. Very Slow especially for reports with more than 10K rows. Does anyone know of a formula that is faster than this

 

These are following formulas that I have used and proved to be slow

 

Cumulative = if(not(ISBLANK([_Total GP]));CALCULATE([_Total GP];FILTER(all(Query1[ItemNO]);sum(Query1[SalesGP]) <=[_Total GP])))
 
or 
_Top N = COUNTROWS(TOPN)
([_Ranking]; all(Query1[ItemNO]);[_Total GP]))
 
(where
_Ranking = rankx(all(Query1[ItemNO]);[_Total GP]) and 
_Total GP = sum(Query1[SalesGP]))
2 REPLIES 2
Highlighted

Re: Cumulative Total Formula is very Slow

try to build it with a quick measure (comulative)....and see how it behaves

mimi Regular Visitor
Regular Visitor

Re: Cumulative Total Formula is very Slow

Hi

 

Thanks for replying. I have tried using Running Total Quick Measure. Same problem. very slow