How to filter by 2 states at once

[Anonymous]

Remaining tasks = CALCULATE(COUNTROWS('Data source 1'),

KEEPFILTERS('Data source 1'[State]="New" OR [State]="Active"))

Why is this count function not working? How do I summise both? Or would I have to do them in seperate measures and bring them together? 

Thanks!

[ZhangKun · Accepted solution]

You should use || or {} instead of OR.

Remaining tasks = 
CALCULATE(
    COUNTROWS('Data source 1'),
    KEEPFILTERS('Data source 1'[State] IN {"New", "Active"})
)

Remaining tasks = 
CALCULATE(
    COUNTROWS('Data source 1'),
    KEEPFILTERS('Data source 1'[State] = "New" || 'Data source 1'[State] = "Active")
)