Topic: DAX
-
Power BI and Analysis Services are case-insensitive by default.Lowercase letters are identical to uppercase letters.This is mostly a good choice, but it also comes with unexpected consequences. In this article, we run through a set of queries to understand what… Read more
-
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
-
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views. Read more
-
When you apply a multiple selection to a slicer or to a filter, you obtain a logical OR condition between selected items. This article shows how to implement a logical AND condition in a measure instead of the standard OR… Read more
-
You can create static tables in DAX using the DATATABLE function. This article describes the syntax of this new feature and shows when and how to use it. Read more
-
This article describes the syntax and the use cases of the DEFINE TABLE statement in DAX. Read more
-
This article describes the syntax and the use cases of the DEFINE COLUMN statement in DAX. Read more
-
This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. The companion video introduces the scenario and the general… Read more
-
This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. Read more
-
The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. This article explains these side effects and how to write correct DAX code to avoid getting incorrect results. Read more