Cumulative Total Formula is very Slow

[mimi]

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

[christianfcbmx]

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

[mimi]

Hi

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