Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
54 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
26 | |
22 |