Forum Discussion
Slow Switch Statement
Hey, I'm trying to create one measure, that will return other measures based on another unrelated 'Measure' table, that I will use as a column in a Matrix. The below DAX expression does the trick...
I had an issue with something similiar and was able to get away with this via structure formatting of the visuals. If you were to split the variances into separate visuals next to each other you'd experience much better performance I'd imagine. I attached a screenshot of my example with very long switch statements with complex modeling in the underlying measures used in the swith. This entire page takes ~10 seconds to load.
So something like:
- Forecast Variances
- Budget Variances
- All Year Variances
Or you can elect to section based on
- Variances vs versions
- Variances vs time
Either way, I think you can improve performance via thinking about your formatting.