Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Global Unfilled =
CALCULATE(
COUNTROWS('Interpreting') ,
'Interpreting'[Agency] IN { "INT - Glob", "INT - HBC"},
'Interpreting'[status] = "Unfilled"
)
Hope this is helpful to you.
Nathan
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