https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed-with-count-measure/m-p/2822421#M89613 <DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(</SPAN><SPAN>'table'</SPAN><SPAN>),</SPAN><SPAN>'table'</SPAN><SPAN>[state]</SPAN><SPAN>=</SPAN><SPAN>"won"</SPAN><SPAN>)</SPAN></DIV></DIV> Thu, 06 Oct 2022 10:25:39 GMT darry3ni 2022-10-06T10:25:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed-with-count-measure/m-p/2822350#M89609 <P>Hello everyone. I want to create a measure where i have to show the total count of&nbsp; "wins" from a column called "table[state]". The column called "state" has two values, "won" and "lost". I have to show count of wins where state = won. How can we achieve this using measures? Any help would be appreciated.&nbsp;</P> Thu, 06 Oct 2022 09:59:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed-with-count-measure/m-p/2822350#M89609 Anonymous 2022-10-06T09:59:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed-with-count-measure/m-p/2822421#M89613 <DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(</SPAN><SPAN>'table'</SPAN><SPAN>),</SPAN><SPAN>'table'</SPAN><SPAN>[state]</SPAN><SPAN>=</SPAN><SPAN>"won"</SPAN><SPAN>)</SPAN></DIV></DIV> Thu, 06 Oct 2022 10:25:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed-with-count-measure/m-p/2822421#M89613 darry3ni 2022-10-06T10:25:39Z