Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Optimizing SWITCH on slicer selection with Group By Columns

120K subscribers

10K views 2 years ago

Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Article and download: https://sql.bi/792990?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

These chapters are auto-generated

Introduction

Demo

Alternative

Conclusion

Optimizing SWITCH on slicer selection with Group By Columns

239Likes

10,542Views

2023Apr 11

Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Article and download: https://sql.bi/792990?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...

Introduction

Demo

Alternative

Conclusion

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Understanding the optimization of SWITCH

Understanding Group By Columns in Power BI