more help please with dax formula

[Dougers1]

i want my formula to look for to bits of criteria - where it checks for INT Glob i also want it to count anything that says INT - HBC

Global Unfilled = CALCULATE( COUNTROWS('Interpreting') , 'Interpreting'[Agency] = "INT - Glob", 'Interpreting'[status] = "Unfilled" )

Pany help is much appreciated

[WinterMist · Accepted solution]

@Dougers1 

Global Unfilled = 
CALCULATE( 
   COUNTROWS('Interpreting') , 

   'Interpreting'[Agency] IN { "INT - Glob", "INT - HBC"}, 

   'Interpreting'[status] = "Unfilled" 

)

Hope this is helpful to you.

Nathan

[Dougers1]

is it possible that it counts aslong as the agency column has anykind of text in it