Amsterdam, NLHow to return 0 instead of BLANK in DAX
Marco Russo & Alberto FerrariIn this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. Read more
All the secrets of SUMMARIZE
Alberto FerrariSUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
Oct 13-15 - New York City
Nov 10-12 - Sydney
Video Training
Introducing DAX Video CourseFree
Setting the right permissions for users of composite models
Marco RussoWhen you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset… Read more
Development Tools for Power BI and Analysis Services models – Live Event
Past are days of creating data models with a single monolithic tool provided by Microsoft. The required toolbelt includes multiple tools. Most of them are free and open-source. Watch the recording of the SQLBI live event delivered on Wednesday May… Read more
DAX Patterns
Related distinct count
The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension and you need to perform the distinct count of column values in a dimension table only considering items related to transactions… 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