Powerbivisual

Hi  Millar ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
DISTINCT('Table'[Date])

2. Create measure.

Flag =
var _mindate=
MINX(ALLSELECTED('Table 2'),'Table 2'[Date])
var _maxdate=
MAXX(ALLSELECTED('Table 2'),'Table 2'[Date])
return
IF(
    ISFILTERED('Table 2'[Date])=FALSE()&&MAX('Table'[Date]) >=DATE(2023,2,1)&&MAX('Table'[Date])<=TODAY(),1,
    IF(
    ISFILTERED('Table 2'[Date])=TRUE()&&MAX('Table'[Date]) >=_mindate&&MAX('Table'[Date])<=_maxdate,1,0))

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Slicer has no selected value

Slicer selected value

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly