Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Relevant values for Disconnected tables

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 ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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