Filter Table Visual Based on Slicer Selection

[Anonymous]

Hello,

I have a table visual  on my report that is composed of columns from four different tables. One of my slicers is choosing from a list of dates, in the format YYMM, in whole number datatype. I am trying to filter the table visual to include only the rows associated with the YYMM that is less than or equal to the one selected, preferable using a measure.

Any help is appreciated!

[amitchandak]

@Anonymous , Try a measure like

measure =
var _max =maxx(allselected(Date), Date[YYMM])
return
calculate([measure],filter(all(Date),Date[YYMM]<=_max))