Forum Discussion
Cumulative Sum Performance issue
Hi All, I have a formula to calculate cumulative sum which gives the results but it has extremely slow performance : Cumulative at country = VAR AccountRev = FinalTraumaAllocation[Act22] var ...
Hi johnt75
Thank you for the suggestion. I have reformatted DASX.
However, I still have performance issues. It is loading visual in 1 minute.
If the cumulative totals don't need to take account of other filter settings, such as date range, then you could look into moving the calculations into Power Query or creating a summary calculated table in DAX. That way the performance hit would be a one-off during data load and the visuals should be instantaneous.
If you do need to interact with other slicers or filters I am afraid I cannot help further, optimization is not my strong suit.