https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-with-Two-Filters-Return-Blank/m-p/3316359#M124093 <P>You need to use or ( || ) instead of and ( &amp;&amp; ). Also, you're checking the wrong column for Sunny.</P> Wed, 05 Jul 2023 13:24:17 GMT johnt75 2023-07-05T13:24:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-with-Two-Filters-Return-Blank/m-p/3316072#M124077 <P>Hi guys.&nbsp;</P><P>How come the formula I use keeps returning blank?</P><DIV><DIV><SPAN>Sunny and Stormy = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>AVERAGE</SPAN><SPAN>(</SPAN><SPAN>delivery_statistics</SPAN><SPAN>[Time Taken 2]</SPAN><SPAN>),</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>'delivery_statistics'</SPAN><SPAN>,</SPAN><SPAN>'delivery_statistics'</SPAN><SPAN>[Type_of_vehicle]</SPAN><SPAN>= </SPAN><SPAN>"Sunny"</SPAN><SPAN>&amp;&amp;</SPAN><SPAN>'delivery_statistics'</SPAN><SPAN>[Weatherconditions]</SPAN><SPAN> = </SPAN><SPAN>"Stormy"</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Wed, 05 Jul 2023 11:14:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-with-Two-Filters-Return-Blank/m-p/3316072#M124077 jbax70 2023-07-05T11:14:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-with-Two-Filters-Return-Blank/m-p/3316359#M124093 <P>You need to use or ( || ) instead of and ( &amp;&amp; ). Also, you're checking the wrong column for Sunny.</P> Wed, 05 Jul 2023 13:24:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-with-Two-Filters-Return-Blank/m-p/3316359#M124093 johnt75 2023-07-05T13:24:17Z