Forum Discussion
Does having measures slows down calculation?
Hi i have a fairly computational intensive PBI because many calculate are applied for each row in a table and on several slicers. It was working, slowly but was working. Each cell of the matrix was ...
Nevermind, it was a different issue.
There was a measure that has three times the same CALCUALTE (inside some IFs) in the formula.
By moving it outside in a VAR made it out of memory. Weird
For anyone sent here by Google when looking for the title, unused measures do have an impact, but it takes a lot of them. Someone did some tests and found not much impact from 100 measures, but an increasing impact with 1,000 to 20,000 measures. https://datameerkat.com/number-of-measures-matters