Date slicer not impacting measure

[mwvoves]

In one of my datasets, I'm using  a measure to see how many weekend days there have been so far this period. On the actual UI page I have a slicer to select what period you'd like to look at, but the measure doesn't update- for example, when I select period 2, which started on 1/29, the measure should read a value of 1, since Sunday the 29th is the only weekend day thus far for period 2. Instead it reads a value of 9, which is the total number of weekend days so far this year. Any ideas on how to get the slicer to impact the measure below?

Weekend days = Calculate(

COUNT(PERIOD_VIEW[DAY_NAME]),

PERIOD_VIEW[Date]<TODAY(),

PERIOD_VIEW[YEAR]=2023,

OR(PERIOD_VIEW[DAY_NAME]="Sunday",PERIOD_VIEW[DAY_NAME]="Saturday"))

[mwvoves · Accepted solution]

I was able to find a solution using the Selectedvalue function- below is an updated version of the code:

Weekend days = Calculate(

COUNT(PERIOD_VIEW[DAY_NAME]),

PERIOD_VIEW[Date]<TODAY(),

PERIOD_VIEW[YEAR]=2023,

PERIOD_VIEW[PERIOD_NUMBER]= SELECTEDVALUE(PERIOD_VIEW[PERIOD_NUMBER]),

OR(PERIOD_VIEW[DAY_NAME]="Sunday",PERIOD_VIEW[DAY_NAME]="Saturday")

)

[amitchandak]

@mwvoves , You need create a measure for date filter to work

example 

datediff(max(date[Date]), Today(),day) - networkdays(max(date[Date]), Today(),1)

[mwvoves]

What is the "networkdays" function you have? I don't seem to have that in my BI