https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/alternative-for-DISTINCTCOUNT/m-p/4655240#M178213 <P>Hi &nbsp;,&nbsp;</P> <P>Try&nbsp;</P> <P>Countrows +Values function in dax</P> <P><A href="https://gorilla.bi/dax/optimize-distinctcount/" target="_blank" rel="noopener">https://gorilla.bi/dax/optimize-distinctcount/</A></P> <P>&nbsp;</P> <P>Thanks&nbsp;</P> <P>Let me if still facing slowness provide more information about your dax</P> <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1260763" data-lia-user-login="marcel_ncrdb" class="lia-mention lia-mention-user">marcel_ncrdb</a></P> Wed, 16 Apr 2025 07:58:50 GMT mohitkumawat 2025-04-16T07:58:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/alternative-for-DISTINCTCOUNT/m-p/4655238#M178212 <P>hi facing slowness in distinct count DAX&nbsp;</P> Wed, 16 Apr 2025 07:56:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/alternative-for-DISTINCTCOUNT/m-p/4655238#M178212 marcel_ncrdb 2025-04-16T07:56:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/alternative-for-DISTINCTCOUNT/m-p/4655240#M178213 <P>Hi &nbsp;,&nbsp;</P> <P>Try&nbsp;</P> <P>Countrows +Values function in dax</P> <P><A href="https://gorilla.bi/dax/optimize-distinctcount/" target="_blank" rel="noopener">https://gorilla.bi/dax/optimize-distinctcount/</A></P> <P>&nbsp;</P> <P>Thanks&nbsp;</P> <P>Let me if still facing slowness provide more information about your dax</P> <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1260763" data-lia-user-login="marcel_ncrdb" class="lia-mention lia-mention-user">marcel_ncrdb</a></P> Wed, 16 Apr 2025 07:58:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/alternative-for-DISTINCTCOUNT/m-p/4655240#M178213 mohitkumawat 2025-04-16T07:58:50Z