https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/count-column-if-it-has-specific-text/m-p/3555074#M136817 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="635954" data-lia-user-login="Dougers1" class="lia-mention lia-mention-user">Dougers1</a>&nbsp;,</P> <P>&nbsp;</P> <P>How about this?</P> <DIV> <DIV><SPAN>Unfilled = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>('Interpreting'),'Interpreting'[Status] </SPAN><SPAN>in</SPAN><SPAN> ( {</SPAN><SPAN>"Agency Unfilled"</SPAN><SPAN>, </SPAN><SPAN>"Unfilled"</SPAN><SPAN>} ) )</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Let me know if this helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>/Tom<BR /><A href="https://www.tackytech.blog/" target="_blank">https://www.tackytech.blog/</A><BR /><A href="https://www.instagram.com/tackytechtom/" target="_blank">https://www.instagram.com/tackytechtom/</A></SPAN></DIV> </DIV> Mon, 27 Nov 2023 20:57:53 GMT tackytechtom 2023-11-27T20:57:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/count-column-if-it-has-specific-text/m-p/3555008#M136814 <P>how do i get this dax to also count if status = Agency Unfilled + Unfilled</P><P>&nbsp;</P><DIV><DIV><SPAN>Unfilled = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>('Interpreting'),'Interpreting'[Status] = </SPAN><SPAN>"Agency Unfilled"</SPAN><SPAN>)</SPAN></DIV></DIV> Mon, 27 Nov 2023 20:20:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/count-column-if-it-has-specific-text/m-p/3555008#M136814 Dougers1 2023-11-27T20:20:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/count-column-if-it-has-specific-text/m-p/3555074#M136817 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="635954" data-lia-user-login="Dougers1" class="lia-mention lia-mention-user">Dougers1</a>&nbsp;,</P> <P>&nbsp;</P> <P>How about this?</P> <DIV> <DIV><SPAN>Unfilled = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>('Interpreting'),'Interpreting'[Status] </SPAN><SPAN>in</SPAN><SPAN> ( {</SPAN><SPAN>"Agency Unfilled"</SPAN><SPAN>, </SPAN><SPAN>"Unfilled"</SPAN><SPAN>} ) )</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Let me know if this helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>/Tom<BR /><A href="https://www.tackytech.blog/" target="_blank">https://www.tackytech.blog/</A><BR /><A href="https://www.instagram.com/tackytechtom/" target="_blank">https://www.instagram.com/tackytechtom/</A></SPAN></DIV> </DIV> Mon, 27 Nov 2023 20:57:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/count-column-if-it-has-specific-text/m-p/3555074#M136817 tackytechtom 2023-11-27T20:57:53Z