topic Year-to-date calculation with criteria yielding wrong result in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-date-calculation-with-criteria-yielding-wrong-result/m-p/3256898#M120301 <DIV><DIV><SPAN>Basically I'm trying to calculate the sum of acceptedwt for the year to date where sys = 1<BR /><BR />Sys1g = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>1000</SPAN><SPAN>*</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Statistics</SPAN><SPAN>[acceptedwt]</SPAN><SPAN>), </SPAN><SPAN>Statistics</SPAN><SPAN>[sys]</SPAN><SPAN> =</SPAN><SPAN>1</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>Statistics</SPAN><SPAN>[STA_PeriodEnd]</SPAN><SPAN>=Year(today()</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I think the filtering isn't working the way I want it to work.</SPAN></DIV><DIV><SPAN>Any help would be appreciated.</SPAN></DIV></DIV> Sun, 28 May 2023 18:56:11 GMT JimT99 2023-05-28T18:56:11Z Year-to-date calculation with criteria yielding wrong result https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-date-calculation-with-criteria-yielding-wrong-result/m-p/3256898#M120301 <DIV><DIV><SPAN>Basically I'm trying to calculate the sum of acceptedwt for the year to date where sys = 1<BR /><BR />Sys1g = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>1000</SPAN><SPAN>*</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Statistics</SPAN><SPAN>[acceptedwt]</SPAN><SPAN>), </SPAN><SPAN>Statistics</SPAN><SPAN>[sys]</SPAN><SPAN> =</SPAN><SPAN>1</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>YEAR</SPAN><SPAN>(</SPAN><SPAN>Statistics</SPAN><SPAN>[STA_PeriodEnd]</SPAN><SPAN>=Year(today()</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I think the filtering isn't working the way I want it to work.</SPAN></DIV><DIV><SPAN>Any help would be appreciated.</SPAN></DIV></DIV> Sun, 28 May 2023 18:56:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-date-calculation-with-criteria-yielding-wrong-result/m-p/3256898#M120301 JimT99 2023-05-28T18:56:11Z Re: Year-to-date calculation with criteria yielding wrong result https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-date-calculation-with-criteria-yielding-wrong-result/m-p/3256917#M120303 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="384836" data-lia-user-login="JimT99" class="lia-mention lia-mention-user">JimT99</a>&nbsp;Try this:&nbsp;<A href="https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Better-Year-to-Date-Total/m-p/2875532#M908" target="_blank">Better Year to Date Total - Microsoft Fabric Community</A></P> <P><div data-video-id="https://youtu.be/LL_CDYFtgz8" data-video-remote-vid="https://youtu.be/LL_CDYFtgz8" class="lia-video-container lia-media-is-center lia-media-size-medium"><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FLL_CDYFtgz8%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DLL_CDYFtgz8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FLL_CDYFtgz8%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" allowfullscreen="" style="max-width: 100%"></iframe></div></P> Sun, 28 May 2023 19:28:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Year-to-date-calculation-with-criteria-yielding-wrong-result/m-p/3256917#M120303 Greg_Deckler 2023-05-28T19:28:09Z