https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3977173#M154206 <P>Thank you! What if i want a date filter too with a date after 2022-01-02?&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="625922" data-lia-user-login="bhanu_gautam" class="lia-mention lia-mention-user">bhanu_gautam</a>&nbsp;?</P> Thu, 06 Jun 2024 15:18:24 GMT Sammy22 2024-06-06T15:18:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3976751#M154188 <P>Hello,</P><P>&nbsp;</P><P>I am trying to calculate the 'count' column in pBI but am struggling. I need to count the unique number of countries each customer is assigned to, for example John has 4, peter has 1 (Italy).</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Order Number</TD><TD>Customer</TD><TD>Country</TD><TD><FONT color="#00FF00"><STRONG>Count</STRONG></FONT></TD></TR><TR><TD>1a</TD><TD>John</TD><TD>UK</TD><TD>4</TD></TR><TR><TD>2a</TD><TD>David</TD><TD>Mexico</TD><TD>3</TD></TR><TR><TD>3a</TD><TD>Peter</TD><TD>Italy</TD><TD>1</TD></TR><TR><TD>1b</TD><TD>John</TD><TD>Germany</TD><TD>4</TD></TR><TR><TD>2b</TD><TD>David</TD><TD>France</TD><TD>3</TD></TR><TR><TD>3b</TD><TD>Peter</TD><TD>Italy</TD><TD>1</TD></TR><TR><TD>1c</TD><TD>John</TD><TD>UK</TD><TD>4</TD></TR><TR><TD>2c</TD><TD>David</TD><TD>Egypt</TD><TD>3</TD></TR><TR><TD>3c</TD><TD>Peter</TD><TD>Italy</TD><TD>1</TD></TR><TR><TD>4a</TD><TD>John</TD><TD>Poland</TD><TD>4</TD></TR></TBODY></TABLE> Thu, 06 Jun 2024 10:07:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3976751#M154188 Sammy22 2024-06-06T10:07:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3977018#M154198 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="687121" data-lia-user-login="Sammy22" class="lia-mention lia-mention-user">Sammy22</a>&nbsp;, Try using below mentioned DAX measure</P> <P>&nbsp;</P> <P>Count = CALCULATE(DISTINCTCOUNT('Table'[Country]), ALLEXCEPT('Table', 'Table'[Customer]))</P> Thu, 06 Jun 2024 12:22:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3977018#M154198 bhanu_gautam 2024-06-06T12:22:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3977173#M154206 <P>Thank you! What if i want a date filter too with a date after 2022-01-02?&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="625922" data-lia-user-login="bhanu_gautam" class="lia-mention lia-mention-user">bhanu_gautam</a>&nbsp;?</P> Thu, 06 Jun 2024 15:18:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countifs-function-with-unique-element/m-p/3977173#M154206 Sammy22 2024-06-06T15:18:24Z