22-25 April 2026 
To filter or not to filter, that is a question
Regular 50 minute session for SQLBits 2026TL; DR
Let's have fun filtering data with DAX.
Session Details
When working with DAX, filters are everything.
The session covers converting interactive filtering to DAX filters in Power BI reports.
We will cover several internal topics related to DAX filtering.
We will introduce issues related to filter contexts, filter functions, calculated tables created by filters' actions, and the concept of context transition applied to filters.
We will examine how value filter behavior affects query DAX results.
Power BI Performance Analyzer and DAX Studio will be the best tools for demonstrating the concepts during the session.
This session is intended for users who analyze data stored in the Vertipaq SSAS database and need to understand how to filter and interpret the results of their actions.
The session covers converting interactive filtering to DAX filters in Power BI reports.
We will cover several internal topics related to DAX filtering.
We will introduce issues related to filter contexts, filter functions, calculated tables created by filters' actions, and the concept of context transition applied to filters.
We will examine how value filter behavior affects query DAX results.
Power BI Performance Analyzer and DAX Studio will be the best tools for demonstrating the concepts during the session.
This session is intended for users who analyze data stored in the Vertipaq SSAS database and need to understand how to filter and interpret the results of their actions.
3 things you'll get out of this session
Understand the process for querying the Vertipaq storage mode.
Learn how to explore DAX filters with DAX Studio.
Identify the query expressions by looking at the xmSQL code.
Learn how to explore DAX filters with DAX Studio.
Identify the query expressions by looking at the xmSQL code.
Speakers
Ana Maria Bisbe York's other proposed sessions for 2026
Querying data and metadata with T-SQL, M and DAX - 2026
SQL Fabric, the perfect combination of experience and youth - 2026
Ana Maria Bisbe York's previous sessions
Let's define Entities and attributes for tabular models in 20 minutes.
Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.
Lets play with a date field & Time Intelligence in Power BI
Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise
Lets do the cleansing with M and / or Python languages
This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.
Some transformations that can save your ETL in Power BI
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.