Forum Discussion
count column if it has specific text
how do i get this dax to also count if status = Agency Unfilled + Unfilled Unfilled = CALCULATE(COUNTROWS('Interpreting'),'Interpreting'[Status] = "Agency Unfilled")
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi Dougers1 ,
How about this?
Unfilled = CALCULATE(COUNTROWS('Interpreting'),'Interpreting'[Status] in ( {"Agency Unfilled", "Unfilled"} ) )
Let me know if this helps 🙂