Avoid Allexept

[PowerMan1]

Hi, 

I have problem with my running totals. it is very slow. I think it's because of the allexept function.

can i avoid to use allexcept function and made my calculation more optimil ?

Runing Total = 
VAR CurrantIndex = MIN ( 'ShiftTable'[Index] )
VAR LastReset = [ResetIndex]
VAR IndexToUse =
    FILTER (
        ALLEXCEPT ( ShiftTable, Branches[Branch], Kadr_LookUP[Name], 'Date'[Year], 'Date'[Month], 'Date'[Month Day] ),
        ShiftTable[Index] >= CurrantIndex && LastReset = [ResetIndex] )
        
VAR Result = CALCULATE ( SUMX ( ShiftTable, ShiftTable[Real Time] ), IndexToUse )
RETURN Result

[Fowmy]

@PowerMan1 

Can you clarify what your measure is supposed to do here and in what context it runs? 
Why LastReset = [ResetIndex]  is evaluated again whereas you have already assigned a variable above.

[PowerMan1]

i want to reset data with this measure (in every even index):

ResetIndex = 
VAR Res = MAX ( ShiftTable[Index] )
RETURN
IF ( ISODD ( Res ), Res + 1, Res  )

and context is:
year
month
day
branch
personN

sorry for my English

[Ritaf1983 · Accepted solution]

Hi @PowerMan1 
Take a look at the linked discussion:

https://stackoverflow.com/questions/76393885/powerbi-running-total-over-large-number-of-values

may be window () function can help

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly