DAX Optimization Tips for Large Models

Hi Anonymous ,

Optimization of models and DAX measures is not that easy you need to check several parts of your code and understand where it's getting slow.

What I can tell you from the image I see is that having a many to many relationships (even with a single filter) it's not a good option to get a good performance, in this case I'm refering to the PBI_CHALLENGES  and PBI_ELIGMEMBER relationship, but I can see that you also have other relationships like this.

Optimized models with millions and millions of rows need to be in a star schema and this is not the case in this example that is also part of your issues.

Instead of doing a measure to do the Challenge completions you can try and use a Field Parameter that will allow to run each of the metrics individually instead of them running on top of a switch.

Again this is just an high level perspective of what you present, further details need to be done analizing your model closely.