Sum of Working Days till end of this month

[y5famfnatudu]

Dear All,

Some how I can't get the sum of working days till the end of the current month, because I have a filter in the report that is called "isPastDay", how can I overcome this issue?

The measures are as follows:

Working Days = 
CALCULATE (
    COUNTROWS ( FILTER ( 'Date', 'Date'[Date] <= TODAY () ) ),
    'Date'[isWD] = "1"
)

Working Days ToBe = 
CALCULATE (
    COUNTROWS ( 'Date' ),
    'Date'[isWD] = "1",
    REMOVEFILTERS ( 'Date'[isPast] )
)

What I'm expecting to see, is 41 instead of 250

Your help is so much appreciated.

Best regards,

Simon

[y5famfnatudu · Accepted solution]

I got the measure to work

Working Days ToBe =
VAR _EndOfCurrentMonth =
    EOMONTH ( TODAY (), 0 )
VAR _WDtillEndOfCurrentMonth =
    CALCULATE (
        COUNTROWS ( FILTER ( 'Date', Date[Date] <= _EndOfCurrentMonth ) ),
        Date[isWD] = "1",
        REMOVEFILTERS ( Date[isPast] )
    )
RETURN
    _WDtillEndOfCurrentMonth

[bhanu_gautam]

@y5famfnatudu Try using

DAX
Working Days =
CALCULATE (
COUNTROWS ( FILTER ( 'Date', 'Date'[Date] <= TODAY () ) ),
'Date'[isWD] = "1"
)

Working Days ToBe =
CALCULATE (
COUNTROWS ( FILTER ( 'Date', 'Date'[Date] > TODAY() && 'Date'[Date] <= EOMONTH(TODAY(), 0) ) ),
'Date'[isWD] = "1",
REMOVEFILTERS ( 'Date'[isPastDay] )
)

[y5famfnatudu]

Thank you @bhanu_gautam 
The measure Working Days ToBe is showing 10 by Feb, but blank by the rest