Measure to count multiple status

[Zaky]

Hi,

What is the correct measure to count [WO Measurement Status]="Missed" and "Missed Goal"?

I used the following measure and i want to count also "Missed Goal" status.

WO Missed = CALCULATE(COUNTROWS('WO'),'WO'[WO Measurement Status]="Missed")

Thanks

[Zubair_Muhammad · Accepted solution]

@Zaky

You can use IN operator

WO Missed and Missed Goal =
CALCULATE (
    COUNTROWS ( 'WO' ),
    'WO'[WO Measurement Status] IN { "Missed", "Missed Goal" }
)

[Zaky]

Thanks for your help. It's work. 

Regards,

Zaky