https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AVG-Problem/m-p/2206159#M51920 <P>Hey All!</P><P>&nbsp;</P><P>This is my measure:</P><DIV><DIV><SPAN>Net USD average per Day =</SPAN></DIV><DIV><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Date'[Date]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Revenues DB'[Net USD]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I can not reach the exact amount<BR />I think it's because the formula also calculates BLANK<BR />How do I ignore BLANK in such a formula like this?</SPAN></DIV></DIV> Wed, 24 Nov 2021 15:53:48 GMT netanel 2021-11-24T15:53:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AVG-Problem/m-p/2206159#M51920 <P>Hey All!</P><P>&nbsp;</P><P>This is my measure:</P><DIV><DIV><SPAN>Net USD average per Day =</SPAN></DIV><DIV><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Date'[Date]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>'Revenues DB'[Net USD]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I can not reach the exact amount<BR />I think it's because the formula also calculates BLANK<BR />How do I ignore BLANK in such a formula like this?</SPAN></DIV></DIV> Wed, 24 Nov 2021 15:53:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AVG-Problem/m-p/2206159#M51920 netanel 2021-11-24T15:53:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AVG-Problem/m-p/2206247#M51925 <P>If that is the problem, then you could try this:</P> <LI-CODE lang="markup">Net USD average per Day = VAR NetPerDay = ADDCOLUMNS ( VALUES ( 'Date'[Date] ), "Net", CALCULATE ( SUM ( 'Revenues DB'[Net USD] ) ) ) RETURN AVERAGEX ( FILTER ( NetPerDay, NOT ( ISBLANK ( [Net] ) ) ), [Net] )</LI-CODE> <P>&nbsp;</P> <P>I'm pretty sure AVERAGEX already ignores blank values though, so it might be zero values tripping you up rather than blank values. In this case, you could filter for [Net] &gt; 0 rather than NOT ISBLANK ( [Net] ) ).</P> Wed, 24 Nov 2021 16:38:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AVG-Problem/m-p/2206247#M51925 AlexisOlson 2021-11-24T16:38:45Z