count column if it has specific text

[Dougers1]

how do i get this dax to also count if status = Agency Unfilled + Unfilled

Unfilled = CALCULATE(COUNTROWS('Interpreting'),'Interpreting'[Status] = "Agency Unfilled")

[tackytechtom]

Hi @Dougers1 ,

How about this?

Unfilled = CALCULATE(COUNTROWS('Interpreting'),'Interpreting'[Status] in ( {"Agency Unfilled", "Unfilled"} ) )

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/