SQLBits 2024

Using ALLEXCEPT or ALL/VALUES?

Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.

In DAX, ALLEXCEPT is a convenient function to remove filters from a table, except for some columns. Being a CALCULATE modifier, it can lead to unexpected results if not used properly. In this session, we show when to use and when to avoid using it to obtain sound code that works in any situation.

Marco Russo's previous sessions

Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.

Aggregations in Power BI

Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.

Using ALLEXCEPT or ALL/VALUES?

Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.

Understanding window functions in DAX

Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.