https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-help-with-this-dax/m-p/3550910#M136600 <P><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;<BR /><BR />Try this measure:<BR /><BR /></P> <LI-CODE lang="markup"> CALCULATE( COUNTROWS('Export') , 'Export'[Request Grade] = "BSL", 'Export'[status] = "filled" )</LI-CODE> Fri, 24 Nov 2023 13:29:07 GMT Fowmy 2023-11-24T13:29:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-help-with-this-dax/m-p/3550821#M136594 <P>Hi</P><P>&nbsp;</P><P>i have this measure that brings back the total&nbsp; count of BSL requests&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>BSL Total Requests =</SPAN> <SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(</SPAN><SPAN>'Export'</SPAN><SPAN>) ,</SPAN><SPAN>'Export'</SPAN><SPAN>[Request Grade]</SPAN><SPAN> = </SPAN><SPAN>"BSL"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>i need to also see many i have filled - the filled column is named status. what do i need to add so it checks the grade is BSl&nbsp; and then staus is filled</SPAN></DIV></DIV> Fri, 24 Nov 2023 12:18:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-help-with-this-dax/m-p/3550821#M136594 Dougers1 2023-11-24T12:18:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-help-with-this-dax/m-p/3550910#M136600 <P><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;<BR /><BR />Try this measure:<BR /><BR /></P> <LI-CODE lang="markup"> CALCULATE( COUNTROWS('Export') , 'Export'[Request Grade] = "BSL", 'Export'[status] = "filled" )</LI-CODE> Fri, 24 Nov 2023 13:29:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-help-with-this-dax/m-p/3550910#M136600 Fowmy 2023-11-24T13:29:07Z