Forum Discussion
EnrichedUser
5 years agoHelper III
Running Total over 100k Rows - Not Enough Memory
Hi All,
I am trying to determine the running total for a messure called [Inventory Value].
It is too slow and will not process.
Running Total =
VAR InvRank =
RANKX(
ALLSELECTED(Inventory[ItemID]),
[Inventory Value],,
DESC,Dense
)
VAR RunningTotal =
CALCULATE(
[Inventory Value],
FILTER(
ALLSELECTED(Inventory[ItemID]),
InvRank >= RANKX(
ALLSELECTED(Inventory[ItemID]),
[Inventory Value],,
DESC,Dense
)
)
)
RETURN
IF([Inventory Value] <> BLANK(),
RunningTotal)
Sample Table:
| ItemID | COGS | QTY | BranchID |
| 101 | 1 | 5 | AB01 |
| 101 | 1 | 12 | AB02 |
103 | 2 | 43 | AB02 |
| 104 | 3 | 23 | AB01 |
I have on the order of 100 thousand unique part numbers. I am using all selected to record the information by BranchID.
Note: no other visuals/reports have this problem. Everything else has less than a 480 ms load time after clearing the cache.
1 Reply
- AnonymousNot applicable
Hello EnrichedUser
You may try by calculating the InvRank in the calculated column and used that column in the measure.