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 - https://forum.enterprisedna.co/t/slow...

**** 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 IF.EAGER function
25:52 Key takeaways
30:59 ISINSCOPE
31:52 Callback data ID

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial #DataOptimization #PowerBIOptimization