-
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
-
This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do… Read more
-
Almost 18 months ago I compared Azure Analysis Services and Power BI Premium for large datasets. At that time, Azure Analysis Services was a clear choice, but it is almost time to update that post with a longer article. Because… Read more
-
In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Read more
-
You can implement the calculation of stock inventory over time in several ways in DAX. The xVelocity technology in Power Pivot and Analysis Services Tabular is so fast that you might consider both dynamic calculation and snapshot-based calculation, depending on… Read more
-
SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
-
Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and the relational data modeling, there is the expectation that you can perform the same operations as those allowed in SQL.… Read more
-
When you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset… Read more