https://community.qlik.com/t5/Search-the-Community/ALL-EXCEPT-function/m-p/1783357#M57 <P><!-- StartFragment --></P><P><SPAN class="cf0">I need to replicate the below dax Query in qliksense so that i can get the total number of customers(Universe)</SPAN></P><P><SPAN class="cf0">Universe:=</SPAN><SPAN class="cf1">CALCULATE</SPAN><SPAN class="cf0">(</SPAN><SPAN class="cf1">DISTINCTCOUNT</SPAN><SPAN class="cf0">(Portfolios[CUSTOMER]),</SPAN><SPAN class="cf1">FILTER</SPAN><SPAN class="cf0">(</SPAN><SPAN class="cf1">ALLEXCEPT</SPAN><SPAN class="cf0">(Portfolios,Portfolios[CUSTOMER],Portfolios[SUB_CHANNEL],Portfolios[DEPOT]),Portfolios[Division]&lt;&gt;</SPAN><SPAN class="cf1">BLANK</SPAN><SPAN class="cf0">()))</SPAN></P><P><!-- EndFragment --></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 Feb 2021 10:14:10 GMT Winston 2021-02-17T10:14:10Z https://community.qlik.com/t5/Search-the-Community/ALL-EXCEPT-function/m-p/1783357#M57 <P><!-- StartFragment --></P><P><SPAN class="cf0">I need to replicate the below dax Query in qliksense so that i can get the total number of customers(Universe)</SPAN></P><P><SPAN class="cf0">Universe:=</SPAN><SPAN class="cf1">CALCULATE</SPAN><SPAN class="cf0">(</SPAN><SPAN class="cf1">DISTINCTCOUNT</SPAN><SPAN class="cf0">(Portfolios[CUSTOMER]),</SPAN><SPAN class="cf1">FILTER</SPAN><SPAN class="cf0">(</SPAN><SPAN class="cf1">ALLEXCEPT</SPAN><SPAN class="cf0">(Portfolios,Portfolios[CUSTOMER],Portfolios[SUB_CHANNEL],Portfolios[DEPOT]),Portfolios[Division]&lt;&gt;</SPAN><SPAN class="cf1">BLANK</SPAN><SPAN class="cf0">()))</SPAN></P><P><!-- EndFragment --></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 Feb 2021 10:14:10 GMT https://community.qlik.com/t5/Search-the-Community/ALL-EXCEPT-function/m-p/1783357#M57 Winston 2021-02-17T10:14:10Z