Menu

1 / 8

How to Combine Contradictory Filters in DAX

Reading 0:00
15s threshold

Introduction

My last article covered how to handle nested measures that modify the same filter as the calling measure.

If you didn't read it, here it is:

How to Solve Issues When You Nest Measures While Overwriting the Same Filter In DAX, we reuse existing measures all the time when writing new measures. What happens when we write a measure based on another measure and try to change a filter already set in the nested measure? Salvatore Cagliari · 7 min read

But shortly after, I encountered a similar situation where that approach wouldn’t work.

What happened there?

The situation and the data

Imagine a business that receives orders and wants to track the time an order stays in each status.

An order can be in one of the following statuses:

1. Open

2. Pending

3. Preparing for shipment

4. Shipped

5. Billing

6.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.