Forum Discussion

EnrichedUser's avatar
EnrichedUser
Helper III
5 years ago

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:

ItemIDCOGSQTYBranchID
10115AB01
101112AB02

103

243

AB02

104323AB01

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello EnrichedUser 
    You may try by calculating the InvRank in the calculated column and used that column in the measure.