Understanding value filter behavior in SUMMARIZECOLUMNS

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Value filter behavior is a setting in Power BI semantic models that controls how filters are combined in SUMMARIZECOLUMNS. This article explains how it works and suggests its best configuration.
Read more

SQLBI REPLAY

Solving errors in CALCULATE filter arguments

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these conditions and how to solve them.
Read more

COMICS

AI BI Blunders

This comic has been generated by ChatGPT using so many prompts...

#305 · Oct 2025

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Dec 2-4 - Amsterdam

Mastering DAX - 3 DAYS

	Oct 28-30 - Lugano
	Nov 4-6 - Amsterdam
	Nov 12-14 - Chicago
	Dec 8-10 - Austin

video courses

	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Intro to Data Modeling
	Data Modeling for Power BI
	Mastering Tabular
	DAX Tools Video Course
	DAX Patterns
	Power BI Dashboard Design

CLASSROOM COURSES

Mastering DAX in Chicago & Austin

We are offering only two more classroom courses in the United States in 2025: Chicago and Austin, both with Marco Russo!

The goal of these three-day, classroom courses is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. The course includes an overview of the new Calendar feature and the User-defined functions (UDF) in DAX! All the attendees will receive a copy of the e-book, The Definitive Guide to DAX.

Come join Marco before seats run out!
These are our last US courses before the end of the year!

» Chicago: November 12-14, 2025

» Austin: December 8-10, 2025

BI-WEEKLY NEWS DIGEST

Latest news

	• A deep dive into SQLBits 2026: why data pros still need conferences Simon Sabin (SQLBits founder/director) and Marco Russo try to answer one simple question: why bother with conferences in 2026? Well, to meet peers, ask real questions, and learn from battle-tested content (as opposed to vendor demos). Sep 27, 2025 · Simon Sabin
	• DAX UDFs: Code once, reuse everywhere (Preview) The launch of user-defined functions in DAX has exceeded our expectations. In our last newsletter, we launched our first article and video about DAX UDFs. You will also find below a link to the YouTube video where Marco and Jay discussed this two weeks ago. Here is the official Microsoft announcement. If you haven't been paying attention, you should be. Sep 23, 2025 · Microsoft
	• Visit daxlib.org to view, try, and publish public, open-source UDFs in DAX! Visit daxlib.org to find the ever-increasing number of DAX libraries already available. We are working to improve the website, the community is publishing new libraries, you just have to use them! Sep 16, 2025 · SQLBI
	• Calendar-based time intelligence: time intelligence, tailored (Preview) The second big announcement in September was the new calendar-based time intelligence. Our article and video in the last newsletter went deep into how to create calendars, and here is the official Microsoft announcement. Sep 22, 2025 · Microsoft
	• TMDL view (Generally Available) The main consequence of the general availability of TMDL View is that external tools can now modify all the elements of the semantic models without entering unsupported scenarios. No more excuses for using external tools and TMDL! Sep 24, 2025 · Microsoft
	• Deep dive into editing semantic models in the Power BI service (Generally Available) You can now also create a new semantic model using Power BI service, and go beyond just editing an existing semantic model. The article includes a link to all the limitations. Of course, you cannot have the complete toy on the web! Sep 22, 2025 · Microsoft
	• KPIs in Power BI semantic models With TMDL view you can now create KPIs in Power BI! You no longer need an external tools to implement the KPIs as we had described in a previous article. Sep 25, 2025 · Zoe Douglas
	• Tabular Editor 2.27.2 The free version of Tabular Editor now supports DAX UDFs, Calendars, and import TMDL to get libraries from DaxLib. Plus many bugfixes. Update now. Sep 30, 2025 · Daniel Otykier

SQLBI YOUTUBE CHANNEL