Pro DAX and Data Modeling in Power BI: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. AspinPro DAX and Data Modeling in Power BIhttps://doi.org/10.1007/978-1-4842-8995-2_17

17. Beyond the Data Model

Adam Aspin¹  

(1)

STAFFORD, UK

 

Up until now this book has taught you how to create DAX that is built upon (and uses) a basic Power BI data model. Essentially this meant

• Only using data that was imported as the basis for calculations

• Using the table relationships that were created in the initial data model

• Using the filter direction that was defined in the data model

While it is perfectly possible to solve most (and in some cases all) of your analytical challenges in Power BI using only a “classic” data model, there will inevitably be times when you ...