Forum Discussion
Rolling Calculation
Hi Smoupre, thanks for the quick response!
I've tried quick measure, which gives me the following formula:
cumulative =
CALCULATE(
SUM('excel-planning production_progress'[boxes_done]);
FILTER(
ALLSELECTED('excel-planning production_progress'[last_change]);
ISONORAFTER('excel-planning production_progress'[last_change]; MAX('excel-planning production_progress'[last_change]); DESC)
)
)
This formula provides me with the same results (problems) as described before.
Thanks
Hi Smoupre,
The measure works, thanks :) . Only now I encounter another problem.
I have to filter on ordernumber, if I unfilter, it takes forever to load the visual. If I delete the measure everything works fine. Do you have any tips that we can use in order to make the visual work smoothly?
I read something about a poorly written measure, but since we used quick measure I think that would be odd.
Sorry for the inconvenience.
Vincent
- Greg_Deckler
Community Champion
Well, how many records are we talking about here? The only function that I can think of that could be slowing things down would be ISONORAFTER, the other functions are pretty standard and we aren't doing anything like a MAXX. But, that particular function might be causing some issues potentially.
Sorry for the late response,
The database which I use for the running total consists of 2600 rows. The amount of rows will grow each day by lets say 80 to 100 units.
So the database itself is not that big right now. Is there any way to bypass the ISONORAFTER?
- Greg_Deckler
Maybe a simple <= filter?
