Forum Discussion
Solved
more help please with dax formula
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
Global Unfilled =
CALCULATE(
COUNTROWS('Interpreting') ,'Interpreting'[Agency] IN { "INT - Glob", "INT - HBC"},
'Interpreting'[status] = "Unfilled"
)
Hope this is helpful to you.
Nathan
2 Replies
Global Unfilled =
CALCULATE(
COUNTROWS('Interpreting') ,'Interpreting'[Agency] IN { "INT - Glob", "INT - HBC"},
'Interpreting'[status] = "Unfilled"
)
Hope this is helpful to you.
Nathan
is it possible that it counts aslong as the agency column has anykind of text in it
