-
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
-
When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides a workaround, and its restrictions. Read more
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
This article describes the difference between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence functions that are syntax sugar of these two. Read more
-
This article describes the use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns. Read more
-
This article describes how to join tables in DAX when there are no relationships in the data model. The data lineage plays an essential role in this scenario. Read more
-
This article describes the practical uses of NATURALLEFTOUTERJOIN and NATURALINNERJOIN in DAX. These functions are not commonly used in DAX because they do not have the same flexibility as the corresponding concepts in SQL. Read more