Relevant values for Disconnected tables

[praveenpasila]

Hi All,

We have created disconnected tables for start and end dates. we are using them to display data between the start and end date ranges when they are selected in slicer.

This works fine using below formula

Filter Dates =

VAR StartDate = SELECTEDVALUE('Disc Start Date'[Start Date])

VAR EndDate = SELECTEDVALUE('Disc End Date'[End Date])

VAR SummaryDate = MAX('Table1'[Calendar Date])

RETURN

IF ( SummaryDate >= StartDate && SummaryDate <= EndDate, 1, BLANK())

I want to make the start and end dates show relavent value in slicer based on any other slicer selection

Is there a way to do that please suggest.

Thanks in advance

[amitchandak]

@praveenpasila , do you need something like

Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Table,Table[Date] <=_max && Table[Date] >=_min) )

if needed refer similar example

Select data between months - https://youtu.be/nEt7dT3Tfv4

[praveenpasila]

Hi @amitchandak ,

Tried the measure but it is not working.

may be I confused the forum just to make sure we have more clarification adding screen shots below please find below

Selecting the date slicers and other slicer such as "Code" the data is displaying fine in all the charts.

But when a specific "Code" is selected the date slicers are not showing relavent values its showing all dates from the respective disconnected tables 

Can we make them show only relavent values and not all dates from the Disc tables