Measure adds extra dates not included in slicer

[eddd83]

I have uploaded my 2 pbix files. There are also text box explanations here: https://drive.google.com/drive/folders/13bSIFjCPD4ES8mOgY-edrRboo93ZjWgR?usp=sharing

Basically when my table only has dates, the slicer works as normal. However, when i add my measure, now the table includes all dates and the slicer now doesn't work on said table. I created a secondary file with the cross filter direction set to "both", but a) it doesn't solve my original problem and b) it now causes the measure to calculate incorrectly.

Help?

EDIT: in my actual file (my google drive link is a stripped down version for business confidentially reasons), the cross filter = both did work, but the measure still didn't work.

[johnt75]

Replace the Tides_Dim[Date] in your visual with DateDim[Date], it is that date which is being affected by your slicer

[eddd83 · Accepted solution]

I ended up adding a number of filters into my filter bar and for now, it works for my end users

[amitchandak]

@eddd83 , if the measure has +0 or it had data for those additional dates, then additional dates will be added

[eddd83]

in my measure, i changed my variable in my measure and it now doesn't return a value for the false condition

VAR Final_result =
    IF ( North_count > 1, 1 )

ideally, in the table, between March 25 and 26, there would be a value of zero.

is there a way of modifying my measure to show values of zero between march 25 and 26, and not include values outside the slicer?