John on 08 Feb 2018 00:59:11
I have a report with over 50 different measures. Many of these are cumulative calculations. I have found that as I add additional measures, it slows things down with each new measure - to the point that even for a small change in one of my measures - it takes about 2-5 minutes from the time I hit enter, to the time the "Working on it..." box goes away and I am able to use the report again.
This is very frustrating, so to fix this, I went through and commented out around 20 of my measures. Now the report seems blazing fast. It would be extremely useful if there was a way to prevent refresh of certain measures so I don't have to comment and de-comment every measure when I want to add something...