Selecting rows with slicer doesn't work

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.

Hi,

Thanks for the solution Ashish_Mathur  and elitesmitpatel  and foodd  provided, and i want to offer some more infotmation for user to refer to.

hi a_nijsten , you can create a measure

MEASURE =
VAR a =
    MAX ( Datetable[Date] )
VAR b =
    EOMONTH ( a, -1 ) + 1
RETURN
    CALCULATE (
        COUNTROWS ( Testdata ),
        Testdata[Startdate] <= a,
        OR ( Testdata[Enddate] >= b, Testdata[Enddate] = BLANK () ),
        CROSSFILTER ( Datetable[Date], Testdata[Startdate], NONE )
    )

Outptut

Best Regards!

Yolo Zhu

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