https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Male-Female-Ratio-in-the-Gender-column/m-p/1399720#M25739 <DIV>Is this the correct way to find the Male / Female Ratio in the Gender column using dax?</DIV><DIV>&nbsp;</DIV><DIV><SPAN>--&gt; Gender Ratio = COUNTROWS(Employees)/COUNTROWS(ALL(Employees[Gender]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><img /></SPAN></DIV><DIV>&nbsp;</DIV> Mon, 28 Sep 2020 15:01:57 GMT dan--ctvmarks 2020-09-28T15:01:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Male-Female-Ratio-in-the-Gender-column/m-p/1399720#M25739 <DIV>Is this the correct way to find the Male / Female Ratio in the Gender column using dax?</DIV><DIV>&nbsp;</DIV><DIV><SPAN>--&gt; Gender Ratio = COUNTROWS(Employees)/COUNTROWS(ALL(Employees[Gender]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><img /></SPAN></DIV><DIV>&nbsp;</DIV> Mon, 28 Sep 2020 15:01:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Male-Female-Ratio-in-the-Gender-column/m-p/1399720#M25739 dan--ctvmarks 2020-09-28T15:01:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Male-Female-Ratio-in-the-Gender-column/m-p/1399782#M25741 <P>I suggest to try:</P><LI-CODE lang="markup">calculate(countrows(employees) , [Gender] = "Male") / calculate(countrows(employees) , [Gender] = "Female")</LI-CODE><P>&nbsp;</P><P>Kind regards, Steve.&nbsp;&nbsp;</P> Mon, 28 Sep 2020 15:41:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-Male-Female-Ratio-in-the-Gender-column/m-p/1399782#M25741 stevedep 2020-09-28T15:41:11Z