Retaining list while filtering

[die_kruzen]

Hello all. Hoping to get some thoughts on an issue I am having. I have visual that draws from three, different tables. If I filter via the filter panel on column two, using dates greater than 9/1/2023 two entries disappear leaving only the top row. What I would like is that all rows remain and the 5/1/2023, 8/22/2023 values are removed. Is that possible?

Thanks all.

A	10/20/2023	5
B	5/1/2023	20
C	8/22/2023	15

After filtering

A	10/20/2023	5
B		20
C		15

[die_kruzen]

@amitchandak  - thank you for the quick response. I am going to give this a try tomorrow at the office (don't have PBI at home). Also, thanks for passing along the youtube video. Always good to have another video option!

[amitchandak]

@die_kruzen , Create a measure

Max(Table[Date]) +  0

and try

Or have disconnected data table and create a filter on that

and use measure like 

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
If( Max('Table'[Date]) >=_min && Max('Table'[Date]) <=_max, Max('Table'[Date]) &"", "" )

Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI