https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-ALL-function-and-Filter/m-p/2150708#M49554 <P>I have a gauge visual that I would like to create a MAX value for.&nbsp; The MAX should not use any of the filters on the GAUGE visual so I am using ALL function.&nbsp; However I want to Filter on the ALL results by DateCreated so that the total count is only records created after a certain date.</P><P>&nbsp;</P><P>This is what I am using but it is not filtering by the datecreated so I am getting totalrows in the entire table.&nbsp; How can I fix this?&nbsp; thanks!</P><P>&nbsp;</P><DIV><DIV><SPAN>TotalRows = </SPAN><SPAN>COUNTX</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Requests</SPAN><SPAN>),</SPAN><SPAN>[DateCreated]</SPAN><SPAN>&gt;</SPAN><SPAN>3</SPAN><SPAN>/</SPAN><SPAN>17</SPAN><SPAN>/</SPAN><SPAN>2017</SPAN><SPAN>),</SPAN><SPAN>[DateCreated]</SPAN><SPAN>)</SPAN></DIV></DIV> Fri, 22 Oct 2021 15:15:05 GMT hmeltonPSL 2021-10-22T15:15:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-ALL-function-and-Filter/m-p/2150708#M49554 <P>I have a gauge visual that I would like to create a MAX value for.&nbsp; The MAX should not use any of the filters on the GAUGE visual so I am using ALL function.&nbsp; However I want to Filter on the ALL results by DateCreated so that the total count is only records created after a certain date.</P><P>&nbsp;</P><P>This is what I am using but it is not filtering by the datecreated so I am getting totalrows in the entire table.&nbsp; How can I fix this?&nbsp; thanks!</P><P>&nbsp;</P><DIV><DIV><SPAN>TotalRows = </SPAN><SPAN>COUNTX</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Requests</SPAN><SPAN>),</SPAN><SPAN>[DateCreated]</SPAN><SPAN>&gt;</SPAN><SPAN>3</SPAN><SPAN>/</SPAN><SPAN>17</SPAN><SPAN>/</SPAN><SPAN>2017</SPAN><SPAN>),</SPAN><SPAN>[DateCreated]</SPAN><SPAN>)</SPAN></DIV></DIV> Fri, 22 Oct 2021 15:15:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-ALL-function-and-Filter/m-p/2150708#M49554 hmeltonPSL 2021-10-22T15:15:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-ALL-function-and-Filter/m-p/2150723#M49557 <P>Hello there&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="193633" data-lia-user-login="hmeltonPSL" class="lia-mention lia-mention-user">hmeltonPSL</a>&nbsp;! Try this:</P><LI-CODE lang="markup">TotalRows = COUNTX(FILTER(ALL(Requests),[DateCreated]&gt; DATE(2017, 3, 17)),[DateCreated])</LI-CODE><P>Hope this answer solves your problem!<BR />If you need any additional help please <SPAN>@</SPAN> me in your reply.<BR />If my reply provided you with a solution, please consider marking it as a solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span> or giving it a kudoe <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><BR />Thanks!<BR /><BR /><A href="https://www.linkedin.com/in/gon%C3%A7alo-costa-b32253159" target="_blank">You can also check out my LinkedIn!</A><BR /><BR />Best regards,<BR />Gonçalo Geraldes</P><P>&nbsp;</P> Fri, 22 Oct 2021 15:23:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-with-ALL-function-and-Filter/m-p/2150723#M49557 goncalogeraldes 2021-10-22T15:23:43Z