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.
Speakers
Marco Russo's previous sessions
Advanced DAX
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.