topic Re: Count with filter based on service colomns in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244798#M168061 <P>Dear&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="796215" data-lia-user-login="dharmendars007" class="lia-mention lia-mention-user">dharmendars007</a>&nbsp;</P><P>Thank you for this proposition; but the Distinct Count should be based on the ID column insteand of service.</P><P>So, below is the solution:</P><DIV><P>&nbsp;</P><P><SPAN>Number of Mental Health =</SPAN></P><DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = </SPAN><SPAN>"Mental health"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;&nbsp;</DIV><DIV><DIV><SPAN>Number of familly =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = </SPAN><SPAN>"Familly"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><SPAN>Number of Legal Assistance =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = "</SPAN><SPAN>Legal Assistance"</SPAN><SPAN>)</SPAN></DIV></DIV></DIV></DIV></DIV> Wed, 16 Oct 2024 13:01:06 GMT dofrancis3 2024-10-16T13:01:06Z Count with filter based on service colomns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244733#M168055 <P>Dear colleagues !</P><P>Please could you help me with DAX Mesure that can allow me to have number of each service</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 16 Oct 2024 11:40:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244733#M168055 dofrancis3 2024-10-16T11:40:50Z Re: Count with filter based on service colomns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244779#M168060 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683724" data-lia-user-login="dofrancis3" class="lia-mention lia-mention-user">dofrancis3</a>&nbsp;,&nbsp;</P><P>&nbsp;</P><P>Please try the below measures..</P><P>&nbsp;</P><P>Number of Legal Assistance =<BR />CALCULATE(<BR />COUNT('Dataset'[Service]),<BR />'Dataset'[Service] = "Legal assistance")</P><P>&nbsp;</P><P>Number of Mental Health =<BR />CALCULATE(<BR />COUNT('Dataset'[Service]),<BR />'Dataset'[Service] = "Mental health")</P><P>&nbsp;</P><P>Number of Family =<BR />CALCULATE(<BR />COUNT('Dataset'[Service]),<BR />'Dataset'[Service] = "Family")</P><P>&nbsp;</P><P><EM><U><STRONG>If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> are much appreciated!</STRONG></U></EM></P><P>&nbsp;</P><P>Thank You</P><P>Dharmendar S</P><P><A href="https://www.linkedin.com/in/dharmendar-s-b5b43463/" target="_blank" rel="noopener"><SPAN>LinkedIN</SPAN></A><SPAN>&nbsp;</SPAN></P> Wed, 16 Oct 2024 12:07:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244779#M168060 dharmendars007 2024-10-16T12:07:26Z Re: Count with filter based on service colomns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244798#M168061 <P>Dear&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="796215" data-lia-user-login="dharmendars007" class="lia-mention lia-mention-user">dharmendars007</a>&nbsp;</P><P>Thank you for this proposition; but the Distinct Count should be based on the ID column insteand of service.</P><P>So, below is the solution:</P><DIV><P>&nbsp;</P><P><SPAN>Number of Mental Health =</SPAN></P><DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = </SPAN><SPAN>"Mental health"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;&nbsp;</DIV><DIV><DIV><SPAN>Number of familly =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = </SPAN><SPAN>"Familly"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><SPAN>Number of Legal Assistance =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[ID]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'GBV_Mapping_CAR'</SPAN><SPAN>[Service]</SPAN><SPAN> = "</SPAN><SPAN>Legal Assistance"</SPAN><SPAN>)</SPAN></DIV></DIV></DIV></DIV></DIV> Wed, 16 Oct 2024 13:01:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-filter-based-on-service-colomns/m-p/4244798#M168061 dofrancis3 2024-10-16T13:01:06Z