Topic: DAX
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. Read more
-
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
-
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
-
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. Read more
-
This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations. Read more
-
This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context. Read more
-
The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing this behavior is the next step in learning DAX once you understand row context and filter context. This… Read more
-
This article describes the different approaches to format your DAX measures in Power BI semantic models using format custom and dynamic format strings. Read more
-
DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your… Read more