Munich (München), DEUnderstanding the optimization of SWITCH
Marco Russo & Alberto FerrariThe SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Read more
Using SELECTEDVALUE with Fields Parameters in Power BI
Marco RussoIf you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calculation error in measure ‘Sales'[Selection]: Column [Parameter] is part of composite key, but… Read more
Nov 9-11 - Chicago
Dec 5-7 - Amsterdam
Sep 28-30 - Brisbane
Video Training
Introducing DAX Video CourseFree
Using KEEPFILTERS in DAX
This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and improves performance. Read more
Creating your own Contoso star schema database
When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases. We also wanted to be able to control the content so that different… Read more
DAX Patterns
Dynamic segmentation
The Dynamic segmentation pattern is useful to perform the classification of entities based on measures A typical example is to cluster customers based on spending volume The clustering is dynamic so that the categorization considers the filters active in the… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
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