Filtering a Calendar Slicer with other Calendar slicer

[Alejandro]

Hello,

I have two calendar slicers (with two calendar tables associated):

- One for general filtering

- Another to select a previous period to compare with.

I want that the general slicer to filter the comparator slicer: Doing that Min Date (minus one day) on general slicer would be max date on comparator slicer.

Something like this:

So, to do that I created a Measure (ShowDate ) that indicates that and I filtered the comparator slicer with that measure:

ShowDate =

var  MinSelected = MIN('Calendar'[Date])

var MaxCompare = MAX('Calendar_Comparations'[Date])

return

IF(MinSelected > MaxCompare , 1 , 0)

All is working fine until on the comparator slicer I select as last date the min date (minus one day) of the general one, the filter is not working well:

Max date posible is selected on the comparator slicer:

Otherwise is working well:

Why is this happening, it is a bit wierd, what I am doing wrong?

Thanks

[amitchandak]

@Alejandro , this approach os using a  measure based on other filter do not work well with range slicer

a measure like this can help, but work for a list or drop-down

filter date2 slicer using date 1

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( count(Date2[Date]), filter('Date2', 'Date2'[Date] >=_min && 'Date2'[Date] <=_max))

check for non blank