Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Sign in

Filter columns, not tables, in DAX

SQLBI

SQLBI

121K subscribers

Subscribe

Subscribed

726

Share

Save

18K views 9 months ago

18,633 views • Aug 27, 2024

Why you should always filter columns and never filter tables with CALCULATE in DAX! Article and download: https://sql.bi/847199?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more

...more

Comments 61

Top comments

Newest first

Chapters

These chapters are auto-generated

Intro

0:00

Demo

1:25

Large transactions

2:55

Large revenues

6:13

Expanded tables

9:01

Speed

14:08

Conclusion

19:06

Sync to video time

Description

Filter columns, not tables, in DAX

726Likes

18,633Views

Aug 272024

Why you should always filter columns and never filter tables with CALCULATE in DAX! Article and download: https://sql.bi/847199?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Chapters

View all

Intro

0:00

Demo

1:25

Large transactions

2:55

Large revenues

6:13

Transcript

Follow along using the transcript.

Show transcript

SQLBI

121K subscribers

Videos

About

Marco Russo on Twitter

Alberto Ferrari on Twitter

LinkedIn

Facebook

Transcript

20:42

Now playing

Row Context in DAX

SQLBI

SQLBI

•

114K views 3 years ago

19:19

Now playing

Highlighting a data point and comparing all others in a distribution

SQLBI

SQLBI

•

8.1K views 10 months ago

26:36

Now playing

When are variables evaluated in DAX

SQLBI

SQLBI

•

15K views 11 months ago

15:18

Now playing

10 Excel Formula Symbols You Wish You Knew Years Ago

MyOnlineTrainingHub

MyOnlineTrainingHub

Verified

•

105K views 2 weeks ago

11:38

Now playing

Unexpected DAX results using SUMX

Story BI - Mark Walter

Story BI - Mark Walter

•

192 views 2 weeks ago

30:55

Now playing

Solving errors in CALCULATE filter arguments

SQLBI

SQLBI

•

33K views 2 years ago

28:30

Now playing

Differences between GROUPBY and SUMMARIZE

SQLBI

SQLBI

•

47K views 1 year ago

17:11

Now playing

Joins in MySQL | Intermediate MySQL

Alex The Analyst

Alex The Analyst

Verified

•

270K views 1 year ago

28:24

Now playing

Best practices for using KEEPFILTERS in DAX

SQLBI

SQLBI

•

17K views 1 year ago

26:35

Now playing

7 reasons DAX is not easy

SQLBI

SQLBI

•

43K views 3 years ago

20:07

Now playing

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

Havens Consulting

Havens Consulting

•

2.4K views 3 years ago

16:03

Now playing

Filter Context in DAX

SQLBI

SQLBI

•

82K views 3 years ago

17:15

Now playing

What's Left of Iran's Nuclear Bunkers?

Cappy Army

Cappy Army

Verified

•

880K views 1 day ago

New

13:51

Now playing

Apache Iceberg: What It Is and Why Everyone’s Talking About It.

Confluent Developer

Confluent Developer

•

428K views 2 months ago

24:40

Now playing

Filter context in DAX explained visually

SQLBI

SQLBI

•

38K views 1 year ago

17:29

Now playing

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

Maven Analytics

Maven Analytics

•

393K views 1 year ago

10:08

Now playing

DAX Fridays Battle #188: FILTER vs CALCULATETABLE - Avoid using FILTER as a filter argument

Curbal

Curbal

Verified

•

22K views 4 years ago

33:22

Now playing

SQL Table Partitioning Explained: Optimize Big Table Performance | #SQL Course 42

Data with Baraa

Data with Baraa

•

18K views 7 months ago

18:56

Now playing

When to use KEEPFILTERS over iterators

SQLBI

SQLBI

•

52K views 4 years ago

21:45

Now playing

Row context in DAX explained visually

SQLBI

SQLBI

•

28K views 10 months ago