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
1 view
1710
510
1 week ago 00:15:02 1
2,000 Year Old Telephone In Chimu?
1 week ago 00:03:33 1
पर्यटन (337) | NIOS TMA Ready To Upload Handwritten Assignment File | Class 12 Session 2025
1 week ago 00:20:19 1
Americans Find Heartwarming Stories on Chinese App RedNote
1 week ago 00:36:09 1
Why Fun Projects Are the Key to Saving This Building
1 week ago 01:05:38 1
SKINWALKING OWLS, WATER SPIRITS, BLUE LADIES AND SILVER UFOS (SN 18 EP 33) TRUE PARANORMAL STORIES
1 week ago 00:31:53 4
Tokyo Xtreme Racer - Customizing and Fully Upgrading 350Z
1 week ago 00:03:49 1
Battling a Dead Battery? TOPDON BT100 is Your Ultimate Weapon! - YouTube
1 week ago 00:04:36 1
Бессмертный хит. Сидни Ром “Hearts“ (1982г)
1 week ago 00:03:12 1
Spoofing Pokermon GO - How to Get Pokemon GO Hack iOS & Android with Joystick, Teleport 2025
2 weeks ago 00:02:42 1
Pokemon TCG Pocket Hack iOS & Android - How to Get Poke God, Free Tickets with Pokemon TCG MOD APK
2 weeks ago 00:00:58 1
TrustHerb Sea Salt: The Natural Secret to Better Health and Flavor! #seasalt #PureSeaSalt #trustherb
2 weeks ago 00:07:15 1
January 2024 Fino Payments Bank |Distributor Incentive Scheme | How to Earn 50K Plus Income in Hindi
2 weeks ago 00:32:17 2
The Dark World of Megachurches
2 weeks ago 00:07:16 1
Новости ВИП прорубь.Недорого
2 weeks ago 00:02:32 2
Dragon Ball Legends Hack/MOD APK iOS & Android - How to Get Unlimited Chrono Crystals in 2025
2 weeks ago 00:44:09 1
How Important To Be Who We Say We Are
2 weeks ago 00:00:20 2
Pro tip: How to easily install blocking
2 weeks ago 01:21:42 2
The Pope, the Environmental Crisis, and Frontline Leaders | The Letter: Laudato Si Film
2 weeks ago 00:02:15 1
Coin Master Hack iOS & Android - How to Get Coin Master Free Unlimited Spins 2025
2 weeks ago 00:27:17 8
PVM НЕ НУЖЕН! RetroScaler2X – RCA, S-Video, YPbPr и RGB? ОБЗОР ЛАЙНДАБЛЕРА
2 weeks ago 01:01:55 3
GREY ALIENS, BLACK SHADOWS AND PALE WHITE CREATURES (SN 18 EP 31) REAL PARANORMAL EXPERIENCES
2 weeks ago 00:11:54 1
Taj Experience | Taj Holiday Village Resort & Spa | Goa | The Offbeat Couple
2 weeks ago 00:03:38 1
Tired of Dry Air and Sleepless Nights? Here’s the Smart Humidifier That Has Your Back! - YouTube
2 weeks ago 00:22:17 1
Как обновить навигацию на MMI 3G+ — Audi A1/A2/A3/A4/A5/A6/A7/A8/Q2/Q3/Q5/Q7/TT (NAVI UPDATE)