Debugging DAX and Modifying Filter Context - Performance Analyzer and DAX Query View

In this video, Mitchell will teach you a valuable tip for debugging DAX and modifying filter context. We will explore how to use the Performance Analyzer and the DAX Query View to gain insights into the calculation.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit prag.works/MITCHELL40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: prag.works/yt-twitter
✔️Facebook: prag.works/yt-fb
✔️Instagram: prag.works/yt-insta
✔️LinkedIn: prag.works/yt-li
✔️Discord: prag.works/yt-discord
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#pragmaticworks
00:00 DAX Debugging and Common Problems
01:57 Attempting to Implement DAX Measure
03:34 Importance of Debugging in DAX
04:36 Utilizing Performance Analyzer and DAX Query View
06:13 Modifying DAX Code to Solve the Problem

[@jasestu]

I got excited for a moment thinking this might help me solve my matrix cross filtering problem where I only want one of the filters from the source matrix to apply to the target cross-filtered Matrix. However, my target matrix needs to display by columns of one of the filters I want to ignore from the source matrix. Looks like I can't have it both ways. Still, great tip to use the performance analyser to see the underlying code.

[@stevenhampson8657]

Any quick tip from Mitchell Pearson is gold. Thanks. 😊

[@mishymoo34]

Thanks dude, really enjoying your videos.

[@nadasdij]

wow - never would have guessed it - thanks for sharing it

[@adrianoschwenkberg6773]

great behind the scenes.. thx

[@flotterotto4491]

Really great advice!

[@workstuff5253]

My guess (@2:56) would be a sort by column for the month name needs removing too.

[@pradeepprabhui6662]

I want to create a floating chart on powerbi to show 4 quartiles... Without downloading any visuals... The floating chart should show 4 funds performance