topic Re: distinct count in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3400425#M128366 <P>Please provide sample data (with sensitive information removed) that covers your issue or question <STRONG>completely</STRONG>. Leave out anything not related to the issue.<BR /><A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR /><A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Sat, 26 Aug 2023 17:05:12 GMT lbendlin 2023-08-26T17:05:12Z distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3399208#M128309 <P>Hello ,</P><P>I want to count how many parts with supplier more than 2 and supplier equal 1</P><TABLE border="1"><TBODY><TR><TD>Part&nbsp;</TD><TD>Supplier</TD></TR><TR><TD>W0030508752R</TD><TD>A</TD></TR><TR><TD>W0030508752R</TD><TD>B</TD></TR><TR><TD>W0030509095H-V1</TD><TD>A</TD></TR><TR><TD>W0030509095H-V1</TD><TD>A</TD></TR><TR><TD>W0030509095H-V1</TD><TD>B</TD></TR><TR><TD>W41013044</TD><TD>C</TD></TR><TR><TD>W41013621</TD><TD>C</TD></TR><TR><TD>W41017168</TD><TD>C</TD></TR><TR><TD>W41017173</TD><TD>C</TD></TR><TR><TD>W41018408</TD><TD>C</TD></TR><TR><TD>W41018445</TD><TD>C</TD></TR></TBODY></TABLE><P>I<SPAN>&nbsp;have done this measure<BR />&nbsp;<FONT color="#339966"><STRONG>Count Supplier = CALCULATE(DISTINCTCOUNT('Table'[Supplier]),ALLEXCEPT('Table','Table'[Part]))</STRONG></FONT><BR /><FONT color="#339966"><STRONG>More than 2 = CALCULATE(DISTINCTCOUNT('Table'[Part]),FILTER(ALL('Table'),[Count Supplier]&gt;=2))</STRONG></FONT><BR /><FONT color="#339966"><STRONG>Equal 1 = CALCULATE(DISTINCTCOUNT('Table'[Part]),FILTER(ALL('Table'),[Count Supplier]=1))</STRONG></FONT><BR />but the value is fixed with date . How can I make it change from date ?<BR /></SPAN></P><P><img /></P><P>&nbsp;</P><P><SPAN>&nbsp;</SPAN></P> Fri, 25 Aug 2023 13:40:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3399208#M128309 MSAYED26 2023-08-25T13:40:48Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3400425#M128366 <P>Please provide sample data (with sensitive information removed) that covers your issue or question <STRONG>completely</STRONG>. Leave out anything not related to the issue.<BR /><A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR /><A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Sat, 26 Aug 2023 17:05:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3400425#M128366 lbendlin 2023-08-26T17:05:12Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3400748#M128396 <P>Thanks for the advice,</P><TABLE border="1"><TBODY><TR><TD>Part&nbsp;</TD><TD>Supplier</TD></TR><TR><TD>W0030508752R</TD><TD>A</TD></TR><TR><TD>W0030508752R</TD><TD>B</TD></TR><TR><TD>W0030509095H-V1</TD><TD>A</TD></TR><TR><TD>W0030509095H-V1</TD><TD>A</TD></TR><TR><TD>W0030509095H-V1</TD><TD>B</TD></TR><TR><TD>W41013044</TD><TD>C</TD></TR><TR><TD>W41013621</TD><TD>C</TD></TR><TR><TD>W41017168</TD><TD>C</TD></TR><TR><TD>W41017173</TD><TD>C</TD></TR><TR><TD>W41018408</TD><TD>C</TD></TR><TR><TD>W41018445</TD><TD>C</TD></TR></TBODY></TABLE><P><SPAN>I want to count how many parts with supplier more than 2 and supplier equal 1&nbsp; and change with date</SPAN></P><P><SPAN>In this example I have the count&nbsp; of parts that have more than or equal 2 supplier is 5 parts and the count of parts that have one supplier is 6 parts&nbsp;</SPAN></P> Sun, 27 Aug 2023 08:30:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3400748#M128396 MSAYED26 2023-08-27T08:30:24Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3401116#M128414 <P>Your sample data does not include dates.&nbsp; That means we cannot comment on the requirement&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">I want to count how many parts with supplier more than 2 and supplier equal 1 and change with date</LI-CODE> Sun, 27 Aug 2023 21:32:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3401116#M128414 lbendlin 2023-08-27T21:32:01Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402119#M128488 <TABLE border="1"><TBODY><TR><TD>Parts</TD><TD>Posting Date</TD><TD>Suppliers</TD></TR><TR><TD>W8TC1806100C</TD><TD>05-01-2020</TD><TD>A</TD></TR><TR><TD>W43002256AC</TD><TD>08-01-2020</TD><TD>B</TD></TR><TR><TD>W63X54HL</TD><TD>08-01-2020</TD><TD>B</TD></TR><TR><TD>W41018395</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43002256</TD><TD>14-01-2020</TD><TD>B</TD></TR><TR><TD>W43002256AC</TD><TD>14-01-2020</TD><TD>B</TD></TR></TBODY></TABLE> Mon, 28 Aug 2023 11:37:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402119#M128488 MSAYED26 2023-08-28T11:37:39Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402176#M128491 <P>your sample data is insufficient to cover your scenarios.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Mon, 28 Aug 2023 12:18:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402176#M128491 lbendlin 2023-08-28T12:18:42Z Re: distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402258#M128494 <TABLE><TBODY><TR><TD>Material</TD><TD>Posting Date</TD><TD>Suppliers</TD></TR><TR><TD>W8TC1806100C</TD><TD>05-01-2020</TD><TD>A</TD></TR><TR><TD>W43002256AC</TD><TD>08-01-2020</TD><TD>B</TD></TR><TR><TD>W63X54HL</TD><TD>08-01-2020</TD><TD>B</TD></TR><TR><TD>W41018395</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>12-01-2020</TD><TD>E</TD></TR><TR><TD>W43002256</TD><TD>14-01-2020</TD><TD>B</TD></TR><TR><TD>W43002256AC</TD><TD>14-01-2020</TD><TD>B</TD></TR><TR><TD>W41018395</TD><TD>14-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>14-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>14-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>14-01-2020</TD><TD>E</TD></TR><TR><TD>W41018395</TD><TD>18-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>18-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>18-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>18-01-2020</TD><TD>E</TD></TR><TR><TD>W430117AC3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430117C3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430117DC3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430317AC3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430317C3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430317DC3S</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W430517C3</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>WC7S100X75</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>WH7S100X75</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>WH8S100X75</TD><TD>20-01-2020</TD><TD>D</TD></TR><TR><TD>W43000493</TD><TD>20-01-2020</TD><TD>G</TD></TR><TR><TD>W43000505</TD><TD>20-01-2020</TD><TD>G</TD></TR><TR><TD>W8TC1806100C</TD><TD>21-01-2020</TD><TD>A</TD></TR><TR><TD>W41018395</TD><TD>21-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>21-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>21-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>21-01-2020</TD><TD>E</TD></TR><TR><TD>W41018395</TD><TD>23-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>23-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>23-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>23-01-2020</TD><TD>E</TD></TR><TR><TD>W0030509095H</TD><TD>25-01-2020</TD><TD>B</TD></TR><TR><TD>W41018395</TD><TD>26-01-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>26-01-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>26-01-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>26-01-2020</TD><TD>E</TD></TR><TR><TD>W43000493</TD><TD>26-01-2020</TD><TD>G</TD></TR><TR><TD>W0030509095H</TD><TD>28-01-2020</TD><TD>B</TD></TR><TR><TD>W63280Z12DNE</TD><TD>28-01-2020</TD><TD>B</TD></TR><TR><TD>W63X54HL</TD><TD>28-01-2020</TD><TD>B</TD></TR><TR><TD>W43002256</TD><TD>30-01-2020</TD><TD>B</TD></TR><TR><TD>W43002256AC</TD><TD>30-01-2020</TD><TD>B</TD></TR><TR><TD>W43000493</TD><TD>30-01-2020</TD><TD>G</TD></TR><TR><TD>W43000493</TD><TD>03-02-2020</TD><TD>G</TD></TR><TR><TD>W43002256</TD><TD>04-02-2020</TD><TD>B</TD></TR><TR><TD>W430117AC3S</TD><TD>04-02-2020</TD><TD>D</TD></TR><TR><TD>W430117C3S</TD><TD>04-02-2020</TD><TD>D</TD></TR><TR><TD>W430117DC3S</TD><TD>04-02-2020</TD><TD>D</TD></TR><TR><TD>W430317C3S</TD><TD>04-02-2020</TD><TD>D</TD></TR><TR><TD>W430317DC3S</TD><TD>04-02-2020</TD><TD>D</TD></TR><TR><TD>W43000493</TD><TD>06-02-2020</TD><TD>G</TD></TR><TR><TD>W43000493</TD><TD>06-02-2020</TD><TD>G</TD></TR><TR><TD>W0030508752R</TD><TD>07-02-2020</TD><TD>B</TD></TR><TR><TD>W63280Z07DNE</TD><TD>07-02-2020</TD><TD>B</TD></TR><TR><TD>W63280Z10DNE</TD><TD>07-02-2020</TD><TD>B</TD></TR><TR><TD>W41018395</TD><TD>10-02-2020</TD><TD>E</TD></TR><TR><TD>W43011994S</TD><TD>10-02-2020</TD><TD>E</TD></TR><TR><TD>W43016101S</TD><TD>10-02-2020</TD><TD>E</TD></TR><TR><TD>W91104433S</TD><TD>10-02-2020</TD><TD>E</TD></TR><TR><TD>41043465H</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W20180227</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W21448072</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41008862</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41013621</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41013814</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41017168</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41017173</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41018408</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41018445</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41019104</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021016</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021255</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021741</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021829</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021881</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021976</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41021980</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41022049</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41022300</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41023685</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41024476</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41026473</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41027093</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41033254</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41034869</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41036197</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41037571</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41038265</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41039460</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41040031</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41040283</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41040979</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41040994</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041005</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041367</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041369</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041380</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041381</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41041608</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41042533</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41042893</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41042927</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41043962</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41044550</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41045967</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41048221</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W41048222</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43000134</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43005378</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43005963</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43008783</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43010381</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43010993</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43012569</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43017575</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43020080</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43020091</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43023852</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W43025155</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W46006726</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W90319302</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W90467903</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91200193</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91400204</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91408004</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91408008</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91602887</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W91602948</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W92250869</TD><TD>10-02-2020</TD><TD>H</TD></TR><TR><TD>W92412188</TD><TD>10-02-2020</TD><TD>H</TD></TR></TBODY></TABLE> Mon, 28 Aug 2023 12:59:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-count/m-p/3402258#M128494 MSAYED26 2023-08-28T12:59:47Z