Forum Discussion

powerbirino3's avatar
powerbirino3
Frequent Visitor
9 years ago

Debug DAX (Thoughts about it)

Hi guys I've been working with Power BI Desktop for about 8 months a lot of hours (at work and at home). Without doubt, the thing that has made me lose more time is making "difficult" measures....
ccakjcrx's avatar
ccakjcrx
Resolver I
8 years ago

Hey powerbirino3!

 

I'm not aware there a standard operating procedure for your problem.

 

I can tell you I've found some good resources. One is Curbal's YouTube channel. Ruth runs that channel, and she has a video that addresses your problem to some extent. Here is a link to that specific video:

 

DAX Fridays! #54: Reverse engineer/ Deconstruct a DAX measure

 

IMO, there isn't really a better resource that addresses the problem you bring up. However, an overall solution would be to purchase the training available on SQLBI.com. Like you, I spent endless days trying to gather info from different sources to come to a better understanding of row & filter context with DAX. I simply gave in and purchased the courses available on SQLBI.com. I cannot tell you how valuable the information is in those courses. There is a significant expense involved, but it is well worth it. 

 

Nothing in the Mastering DAX courses deals with debugging, or stepping through parts of DAX expressions to see how each part of the expression is being calculated; however, the content is so comprehensive it may give you the insight you need to save you a lot of time. 

 

As far as I'm concerned, there simply isn't better resources than vids posted by Curbal & SQLBI.com. The SQLBI guys train Microsoft staff, and present at Microsoft shows.

 

Hope this helps.