Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Using OR conditions between slicers in DAX

120K subscribers

33K views 4 years ago

How to implement a logical OR condition between two slicers of a Power BI report, or of a PivotTable in Excel. By default, when relying on more than one slicer they are considered in an AND condition. This video+article explains how to change this behavior using DAX. Article and sample download: https://sql.bi/66373?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

Problem Statement

Building the Measure

Limitations of the formula

The problem

Conclusion

Using OR conditions between slicers in DAX

858Likes

33,270Views

2020Dec 3

How to implement a logical OR condition between two slicers of a Power BI report, or of a PivotTable in Excel. By default, when relying on more than one slicer they are considered in an AND condition. This video+article explains how to change this behavior using DAX. Article and sample download: https://sql.bi/66373?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

Problem Statement

Building the Measure

Limitations of the formula

Transcript

Follow along using the transcript.

SQLBI

120K subscribers