https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMX-problem/m-p/2960865#M98605 <P>I had a problem while using SUMX.</P><P>I need to count the number of project that start in November, but the total is wrong (as the image bellow).</P><P>I'm so confuse =((</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sun, 11 Dec 2022 16:33:27 GMT hungbm1 2022-12-11T16:33:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMX-problem/m-p/2960865#M98605 <P>I had a problem while using SUMX.</P><P>I need to count the number of project that start in November, but the total is wrong (as the image bellow).</P><P>I'm so confuse =((</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sun, 11 Dec 2022 16:33:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMX-problem/m-p/2960865#M98605 hungbm1 2022-12-11T16:33:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMX-problem/m-p/2960962#M98612 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="484992" data-lia-user-login="hungbm1" class="lia-mention lia-mention-user">hungbm1</a>&nbsp;</P> <P>You're missing context transition. Please try</P> <LI-CODE lang="javascript">Number of new project = SUMX ( DISTINCT ( D_Project[Project Code] ), CALCULATE ( VAR Start_of_period = MIN ( 'Calendar'[Date] ) VAR End_of_period = MAX ( 'Calendar'[Date] ) VAR Start_date_of_project = SELECTEDVALUE ( D_Project[Plan Start date (65)] ) RETURN IF ( Start_of_period &lt;= Start_date_of_project &amp;&amp; Start_date_of_project &lt;= End_of_period, 1, 0 ) ) )</LI-CODE> Thu, 29 Dec 2022 10:58:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUMX-problem/m-p/2960962#M98612 tamerj1 2022-12-29T10:58:56Z