Measure to count multiple status

Question

Hi,&nbsp;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.&nbsp;WO Missed = CALCULATE(COUNTROWS('WO'),'WO'[WO Measurement Status]="Missed")&nbsp;&nbsp;Thanks&nbsp;

zubair_muhammad · Accepted Answer

Zaky
&nbsp;
You can use IN operator
&nbsp;
WO Missed and Missed Goal =
CALCULATE (
    COUNTROWS ( 'WO' ),
    'WO'[WO Measurement Status] IN { "Missed", "Missed Goal" }
)

Forum Discussion

Related content

Multiple measures in matrix by year

How to show multiple metrics/measures in a visual?

Measure 'Contains' multiple.

Measure with multiple filters on same field

Multiple drill through measures