Toronto, ON, CAUnderstanding SUMMARIZECOLUMNS
Marco Russo & Alberto FerrariThis advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices. Read more
AI in Power BI: Time to pay attention
Kurt BuhlerThis article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabric with a large language model (or LLM). Read more
Dec 2-4 - Amsterdam
Oct 1-3 - London
Oct 28-30 - Lugano
Video Training
Introducing DAX Video CourseFree
A few thoughts about newsletter #300 and AI
Marco RussoNewsletter #300 is a significant milestone for SQLBI: it marks nearly 12 years of sending our updates every two weeks. I thought this was a good time to clarify SQLBI’s position on a topic we haven’t discussed much yet: Artificial… Read more
ALLSELECTED best practices
ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. 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.
Optimizing DAX, Second Edition
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more