topic Re: Countif in DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2325193#M58183 <P>Anonymous</LI-USER>&nbsp;Try:</P> <LI-CODE lang="markup">Measure = VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU]) RETURN COUNTROWS(FILTER(__Table,[__BAU]="A"))</LI-CODE> Tue, 08 Feb 2022 09:52:39 GMT Greg_Deckler 2022-02-08T09:52:39Z Countif in DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2325183#M58182 <P>Hi all,</P><P>&nbsp;</P><P>I have a matrix visual created. some of the columns is as below:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>Part No</STRONG></TD><TD><STRONG>BAU</STRONG></TD></TR><TR><TD><P>111</P></TD><TD><P>A</P></TD></TR><TR><TD>222</TD><TD>A</TD></TR><TR><TD>333</TD><TD>A</TD></TR><TR><TD>444</TD><TD>B</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to get a count of the number of part numbers which have BAU as 'A'.</P><P>&nbsp;</P><P>BAU is a measure created.</P><P>&nbsp;</P><P>Any help is appreciated!</P><P>&nbsp;</P><P>Thank you!</P><P>Megha</P> Tue, 08 Feb 2022 09:48:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2325183#M58182 Anonymous 2022-02-08T09:48:12Z Re: Countif in DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2325193#M58183 <P>Anonymous</LI-USER>&nbsp;Try:</P> <LI-CODE lang="markup">Measure = VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU]) RETURN COUNTROWS(FILTER(__Table,[__BAU]="A"))</LI-CODE> Tue, 08 Feb 2022 09:52:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2325193#M58183 Greg_Deckler 2022-02-08T09:52:39Z Re: Countif in DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2326209#M58258 <P>Thank you!&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;</P> Tue, 08 Feb 2022 17:29:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countif-in-DAX/m-p/2326209#M58258 Anonymous 2022-02-08T17:29:28Z