Problem for Optimizing Memory Usage in .pbi File

[jamespereira]

I'm dealing with a .pbi file that has a massive memory issue due to a 134-line switch function, with each line representing a measure (yes, help). Any ideas on how to improve performance? The idea is to create a table with all measures being filtered by quarter.

I've tried improving performance in every possible way and still haven't found a solution.

[Ritaf1983]

Hi @jamespereira 
I don't think that there is a way to help without a deep understanding of your model.
Maybe you can use other functionalities like field parameters/calculation groups.
Or to solve it from the data source by preparing an aggregated view...
I don't see how it is possible to recommend something more specific without a deep examination of your model.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly