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")
1 Reply
Hi Dougers1 ,
How about this?
Unfilled = CALCULATE(COUNTROWS('Interpreting'),'Interpreting'[Status] in ( {"Agency Unfilled", "Unfilled"} ) )Let me know if this helps 🙂
