Slicer only show max value based on month selection from disconnected date table

[DW868990]

Hi, I have a sales amount slicer based on the sales column from a table like below.  On the page, I also have a Month slicer which operates from a disconnected dates table.

I need the sales amount slicer to only show the range for the month which is selected in the disconnected date table.

Any help appreciated.

[amitchandak · Accepted solution]

@DW868990 , Try measure like

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

or

//Date1 is independent Date table
new measure =
var _max = allselected(Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] in _max))

[DW868990]

@amitchandak ah yes, thank you, but i need to apply this to a slicer? So the range in the slicer only shows the min and max for the month selected from the disconnected table.