Filtering with two filters

DAX DAX Calculations
1

Please help. I would like to filter the same column with two different date filters on one table

1
1987×766 30 KB

Sample.pbix (140.7 KB)

2

Sample.pbix (142.6 KB)
Harris, hello!

You need to use ALL (to reset filters) after CALCULATE in your sales measure.
When you need to exclude Calendar_1 this is equal ALL ( ‘Calendar_1’).
When you need to exclude Calendar this is equal ALL (‘Calendar’).

I add this into your file (attached).

Does it help you?

Happy new Year!

BR,
Oleg

1 Like
3

Hello @Harris, just following up if the response from @Oleg.Poddubnyy help you solve your inquiry?

We’ve noticed that no response has been received from you since a few days ago. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

4

Hello @Harris, it’s been a while since we got a response from you.

Please be reminded that In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @Harris, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.