DAX Anti-Patterns Episode Ten - Filter Columns Not Tables! (Part 2) - with Daniil Maslyuk

A lot of videos and articles teach you how to write [DAX]. In this series Daniil Maslyuk and I will show you how avoid bad [DAX] patterns, and in this episode, we're discussing the performance implications of filtering whole tables instead of columns.
GUEST BIO 👤
Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.
RELATED CONTENT 🔗
Bravo (External Tool) -- bravo.bi
DAX Formatter -- www.daxformatter.com
Anti-Patterns Post -- xxlbi.com/blog/power-bi-antip...
Daniil's Blog -- xxlbi.com
Daniil's Twitter -- / dmaslyuk
Daniil's LinkedIn -- / daniilmaslyuk
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Courses -- www.havensconsulting.net/onli...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax

[@mcnater]

Nice overview thanks.

[@BolajiBI]

CALCULATE function has a specific order of evaluation. That's why an inner CALCULATE would overwrite an outer CALCULATE. The FILTER arguments are evaluated before the expression in a CALCULATE function is evaluated.

[@jakeduddy3257]

Calculate behaviour makes sense otherwise you'd be stuck with the outer context. Why keepfilters exists

[@MacPaulos]

Ah ha moment

[@HavensConsulting]

Love having those!