How To Optimize Slow Measures In Power BI

For my first tutorial, I’ll show you how to optimize a Power BI report with slow measures for an incentive plan that involves thorough SWITCH statements. This is part of Enterprise DNA’s new initiative called Optimization Lab, wherein we ask our members to send in their slow-running reports so we can try and see how to optimize and identify where the bottleneck is happening. Antriksh Links mentioned in the video: Slow Measures For Incentive Plan Setup at the Enterprise DNA Forum - ***** Video Details ***** 00:00 Introduction 01:00 The data model 02:29 Date closed filter 02:46 Job list filter 03:15 Matrix visual 04:00 Test running the code 05:36 Main measures 07:05 Incentive % 11:50 IF vs SWITCH statements 13:40 How codes are executed 15:42 Strict evaluation 18:32 Eager evaluation 20:05 Benefits of using eager evaluation 21:15 When to use strict evaluation 23:47 function 25:52 Key takeaways 30:59 ISINSCOP