Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
7 years ago
Solved

Measure to count multiple status

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

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Zaky

     

    You can use IN operator

     

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

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Zaky

     

    You can use IN operator

     

    WO Missed and Missed Goal =
CALCULATE (
    COUNTROWS ( 'WO' ),
    'WO'[WO Measurement Status] IN { "Missed", "Missed Goal" }
)
    • Zaky's avatar
      Zaky
      Icon for Helper IV rankHelper IV
      7 years ago

      Thanks for your help. It's work. :smileyhappy:

       

      Regards,

      Zaky