Forum Discussion
Solved
Avoid Allexept
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 ? Run...
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
Fowmy
Super User
Super UserPowerMan1
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.
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