Topic: Power BI
-
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. 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
-
This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. 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
-
One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one. 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
-
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
-
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 introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. Read more