Between Date Slicer Including dates not in filter

[Anonymous]

I have created a measure that i'm using as a filter on slicers to prevent users from selecting dates that aren't in the time range they've selected in another slicer, e.g. if they choose all sales before October the slicer wont include products that went on sale after that date. 

This has been done through a dax expression as I have pre-existing relationships that prevent me from using a common date table. 

The filter is built using the following code.  

PerfDateFilter = (IF(MAX('TDate Filter'[TDateEnd])> MAX(Artifax_PerfCodes[PerformanceDate]) && Not ISBLANK(MAX(Artifax_PerfCodes[PerformanceDate]))  ,1,0))

When I use a dropdown date slicer it works as expected preventing users from selecting October or November

 

However, when I switch the filter to between dates, it includes sales to the end of the year. Enabling users to select dates that haven't been on sale yet. 

[Kishore_KVN · Accepted solution]

Hello @Anonymous , Please select second slicer and on Edit Interactions under Format Tab then choose Filter in the interaction instead of None. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anonymous]

Thank you @Kishore_KVN that worked!