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
When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this article we describe how composite models and calculation groups work together. Read more
The second year of the pandemic is coming to a close and despite the many uncertainties, we are all striving to push forward and look ahead. For sure, it is a good moment to see what happened in the DAX… Read more
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This article describes the differences between the wholesale and retail modes, along with examples. Read more
The like-for-like sales comparison is an adjusted metric that compares two time periods restricting the comparison to products or stores with the same characteristics In this example we use the like-for-like technique to compare the sales of Contoso stores that… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more
Marco Russo & Alberto Ferrari
Mar 15-17 - New York City
May 11-13 - Sydney
Marco Russo