Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Sign in

Side effects of the Sort By Column setting in DAX

SQLBI

SQLBI

120K subscribers

Subscribe

Subscribed

615

Share

Save

11K views 4 years ago

11,999 views • Dec 22, 2020

The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. Learn how to write correct DAX code to avoid getting incorrect results. Article and download: https://sql.bi/70167?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 66

Top comments

Newest first

Chapters

These chapters are auto-generated

Intro

0:00

Scenario

0:48

Solution

2:45

Sync to video time

Description

Side effects of the Sort By Column setting in DAX

615Likes

11,999Views

2020Dec 22

The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. Learn how to write correct DAX code to avoid getting incorrect results. Article and download: https://sql.bi/70167?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

Scenario

0:48

Solution

2:45

Transcript

Follow along using the transcript.

Show transcript

SQLBI

120K subscribers

Videos

About

Marco Russo on Twitter

Alberto Ferrari on Twitter

LinkedIn

Facebook

Transcript

18:56

Now playing

When to use KEEPFILTERS over iterators

SQLBI

SQLBI

•

52K views 4 years ago

16:45

Now playing

EVERYTHING YOU need to know about SORTING in POWER BI

How to Power BI

How to Power BI

•

70K views 4 years ago

20:42

Now playing

Row Context in DAX

SQLBI

SQLBI

•

113K views 3 years ago

11:34

Now playing

How to add a SIMPLE SORT BUTTON // Switch to Asc or Desc, Change Sort By // Power BI Guide in 2023

Fernan

Fernan

•

6.5K views 1 year ago

14:02

Now playing

Bidirectional relationships and ambiguity

SQLBI

SQLBI

•

121K views 4 years ago

22:00

Now playing

Filtering weekdays in DAX

SQLBI

SQLBI

•

5.3K views 2 months ago

18:14

Now playing

Understanding data lineage in DAX

SQLBI

SQLBI

•

32K views 4 years ago

18:05

Now playing

Comparing DAX calculated columns with Power Query computed columns

SQLBI

SQLBI

•

47K views 4 years ago

17:31

Now playing

Optimizing nested iterators in DAX

SQLBI

SQLBI

•

23K views 4 years ago

7:30

Now playing

No More DAX? Power BI’s NEW Feature Explained (File Included)

MyOnlineTrainingHub

MyOnlineTrainingHub

•

211K views 10 months ago

37:28

Now playing

📊 How to use Power BI DAX - Tutorial

Kevin Stratvert

Kevin Stratvert

•

1.3M views 4 years ago

16:55

Now playing

TopN CONFUSION in Power BI | When the Top3 DOESN'T return 3 items

How to Power BI

How to Power BI

•

59K views 3 years ago

19:18

Now playing

Propagating filters using TREATAS in DAX

SQLBI

SQLBI

•

50K views 4 years ago

3:40:48

Now playing

ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024)

Pragmatic Works

Pragmatic Works

•

611K views 10 months ago

45:55

Now playing

Tools in Power BI

SQLBI

SQLBI

•

10K views 1 month ago

36:46

Now playing

Filter top 3 products with a row for others using DAX in Power BI

SQLBI

SQLBI

•

92K views 4 years ago

9:02

Now playing

[Power BI] 🔎 Sort By Column And Issues That May Arise

Pragmatic Works

Pragmatic Works

•

11K views 3 years ago

22:43

Now playing

Using OR conditions between slicers in DAX

SQLBI

SQLBI

•

33K views 4 years ago

14:43

Now playing

Writing a DAX query using TOPN

SQLBI

SQLBI

•

35K views 4 years ago

27:26

Now playing

Header-detail vs star schema models in Tabular and Power BI

SQLBI

SQLBI

•

28K views 3 years ago