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.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#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

[stevenhampson]

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

[nadasdij]

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

[mishymoo]

Thanks dude, really enjoying your videos.

[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.

[pradeepprabhui]

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