Topic: DAX
-
CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it. Read more
-
In this article we show various techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Read more
-
Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This article introduces the filter context. Read more
-
This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. Read more
-
Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic and provide the reasons why ALLSELECTED requires special attention. Read more
-
This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero. Read more
-
This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions. Read more
-
This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values. Read more
-
This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value is included in a list of values or expressions. Read more
-
A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order. Read more