THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Order of Evaluation in CALCULATE and Clever Hierarchy Handling in #dax

After the first two editions of the SSAS Tabular Workshop, I and Alberto had some time to flush some of the pending activities. We published two articles:

  • Clever Hierarchy Handling in DAX: DAX is not a hierarchy-friendly language, especially if you have a MDX background. If you have to implement hierarchy-based calculation, MDX is still better. But if you need to do that in DAX (for example, because you need this in a DAX measure), then you have to read this article written by Alberto Ferrari that explains how to correctly calculate the classical “ratio to parent” pattern in several different scenarios.
  • Order of Evaluation in CALCULATE Parameters: a common mistake when you start working with DAX is understanding the evaluation order of CALCULATE parameters and what happens when you have nested CALCULATE statements. The topic can be very dense, so I tried to write a simple article that explain the basic concepts and based on the feedback I’ll receive, I’ll consider writing other articles on this subject. So feedback is welcome!

We have other ideas and material that I hope we’ll be able to write and publish in the upcoming weeks. In the meantime, there are plenty of other editions of the workshop this month, starting from the online one next week that is arranged for US time zone. Don’t miss it!

Published Wednesday, May 2, 2012 7:36 AM by Marco Russo (SQLBI)
Filed under: , ,


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement