If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX ), you probably use the following pattern relatively often: [Filtered Measure ] := CALCULATE (     <target_measure>,     FILTER  Read more

Power BI has been on the market one year. My biggest concern, when the product was still in private beta, was the promise of monthly releases made by Microsoft. Today, I can say that the promise was real. I see a long road ahead, in terms of features  Read more

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalent filters using specific DAX patterns. This article show a more efficient technique to apply virtual relationships in DAX…  Read more

If you already installed Analysis Services 2016, you should change the MemoryHeapType setting. There is a new default value (-1), which is an automatic choice that currently applies a new hybrid allocator (which has the number 5 as a value). It should  Read more

Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter…  Read more

Microsoft Press released a free eBook you can already download , Introducing Microsoft Power BI , which I and Alberto Ferrari wrote in the last few months. Please note it is a very introductive book, don’t expect an inside-out. As we wrote in the introduction:  Read more

I wrote many articles and white papers about implementing many-to-many relationships in Analysis Services – for both Multidimensional and Tabular models. For the latter, the same techniques are also useful in Power Pivot and Power BI. With the recent  Read more

The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article.  Read more

With the release of Microsoft SQL Server 2016 , there are several options to use Analysis Services Tabular. SQL Server Standard : it includes Analysis Services Tabular, and it is available in two licensing models: Server + Client Access License (CAL)  Read more

Two years ago I and Alberto Ferrari spent time discussing techniques to calculate new and returning customers, and we wrote the result of our study in the New and Returning Customer article in DAX Patterns web site and book . During one of the Mastering  Read more