Filter Function with OR function returns error

[Anonymous]

I'm trying to usin FILTER and OR function together as shown below

countItem = 
CALCULATE(
    DISTINCTCOUNT('Table'[Item_Number]),
    FILTER('Table','Table'[Active_Date] <= DATE(2021,10,18)),
    OR(
        FILTER('Table','Table'[End_Date] > DATE(2021,11,15)),
        'Table'[End_Date] = BLANK()
        )
        )

I got this error message below

"A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Please help, thanks in advance

[VahidDM · Accepted solution]

HI @Anonymous 

Try this:

countItem =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Item_Number] ),
    FILTER (
        FILTER ( 'Table', 'Table'[Active_Date] <= DATE ( 2021, 10, 18 ) ),
        'Table'[End_Date] > DATE ( 2021, 11, 15 )
            || 'Table'[End_Date] = BLANK ()
    )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/