This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
Almost 18 months ago I compared Azure Analysis Services and Power BI Premium for large datasets. At that time, Azure Analysis Services was a clear choice, but it is almost time to update that post with a longer article. Because… Read more
In 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
SUMMARIZE 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
The Survey pattern uses a data model to analyze correlations between different events related to the same entity such as customer answers to survey questions For example in healthcare organizations the Survey pattern can be used to analyze data about… More on DAX Patterns
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
Amsterdam, NL
Marco Russo & Alberto Ferrari
Marco Russo
Oct 13-15 - New York City
Nov 10-12 - Sydney
Alberto Ferrari