I'm at this point quite experienced in DAX, to the point that my model contains many relationships and 3 complex precalculated tables (so the visuals for the final user are quick and snappy). However, this has a major drawback: EACH time that I
- create a new column
- add a new measure
- rename a measure/column
- pretty much any other modification of the model
recalculates the ENTIRE model. I stay there literally 1 minute or so each time I have to make a modification. Plus everything is very sluggish. As this model is far from complete, this is slowing down a lot my work.
So I would really love a feature, like in excel, "hey, wait a minute to recalculate everything, let me create these 3-4 new measures, and then you can recalculate". I know that there is an idea (I voted for it) but with 3 votes does not seem popular.
Is there therefore any "trick" to avoid recalculation? What I do now is to comment out each of the three main calculated tables and then start working: this of course messes up al the visuals because the calculated tables are not anymore there.
But I would really love a feature to speed up working with large models....any idea?
thanks, i found an somewhat easier solution: save the model as .pbit so it has no data in it. Modify the queries and then reload the data. It helps, but even when the dataset is empty, if you have several relationships and calculated tables it still recalculates after each measure. Of course, without data is faster...
Well, emptying the dataset only improve the issue, but does not resolve it. Still PBI recalculates everything and even with empty data set it still takes a lot when there are many relationship and calculated tables...