© Philip Seamark, Thomas Martens 2019
P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_14

14. Scale Your Models

Philip Seamark1  and Thomas Martens2
UPPER HUTT, New Zealand
Hamburg, Hamburg, Germany


There are two use cases to compose a DAX statement. The first one is to answer a specific question for a given dataset. The second one is to find an answer for a general question; this solution will allow us to answer similar questions much faster in the future.

For this reason, the latter solutions are also called patterns. At first glance, it seems foolish not to use an existing pattern or to develop a new one. But of course, sometimes it’s not that easy because there is no time for the development ...

Get Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.