topic Re: Distinct Count help in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222525#M117842 <P>how do i not show the part numbers that i didnt filter for?</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 May 2023 15:49:34 GMT Anonymous 2023-05-05T15:49:34Z Distinct Count help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222491#M117837 <DIV>&nbsp;</DIV><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 May 2023 18:18:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222491#M117837 Anonymous 2023-05-05T18:18:19Z Re: Distinct Count help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222495#M117838 <P>Hello use calculate(distinctcount(),All(table))</P> Fri, 05 May 2023 15:36:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222495#M117838 eliasayyy 2023-05-05T15:36:10Z Re: Distinct Count help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222525#M117842 <P>how do i not show the part numbers that i didnt filter for?</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 May 2023 15:49:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3222525#M117842 Anonymous 2023-05-05T15:49:34Z Re: Distinct Count help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3228043#M118297 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,<BR /><BR /></P> <P>Please read this blog and then elaborate on what data you have and what your expected output is, which will get your questions solved faster. Thanks.</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly</A></P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener">How to provide sample data in the Power BI Forum</A></P> <P>&nbsp;</P> <P><FONT size="2">Best Regards,<BR />Gao</FONT><BR /><FONT size="2">Community Support Team</FONT></P> <P>&nbsp;</P> <P><FONT size="2">If there is any post<SPAN>&nbsp;</SPAN><FONT size="3" color="#008080"><EM><STRONG>helps</STRONG></EM></FONT>, then please consider<SPAN>&nbsp;</SPAN><FONT size="3"><FONT color="#008080"><EM><STRONG>Accept it as the solution</STRONG></EM></FONT><SPAN>&nbsp;&nbsp;</SPAN></FONT>to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know.<SPAN>&nbsp;</SPAN><FONT color="#008080"><EM><STRONG><FONT size="3">Thanks a lot!</FONT></STRONG></EM></FONT></FONT></P> <P><FONT size="2" color="#FF0000"><A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener"><SPAN>How to get your questions answered quickly</SPAN></A><SPAN>&nbsp;--&nbsp;</SPAN><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener"><SPAN>&nbsp;</SPAN>How to provide sample data in the Power BI Forum</A></FONT></P> Wed, 10 May 2023 02:33:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-Count-help/m-p/3228043#M118297 Anonymous 2023-05-10T02:33:21Z