https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Getting-total-of-a-SUM-based-on-a-specific-data-range/m-p/3055921#M105417 <P>Anonymous</LI-USER>&nbsp;Try this:</P><LI-CODE lang="markup">VAR LastSelectedDate = CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates[Date] ) ) VAR Result = CALCULATE ( [QTD_ATND_2], Dates[Date] &gt; LastSelectedDate ) RETURN Result</LI-CODE> Wed, 01 Feb 2023 18:27:23 GMT AntrikshSharma 2023-02-01T18:27:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Getting-total-of-a-SUM-based-on-a-specific-data-range/m-p/3055890#M105414 <P>Hello everyone!</P><P>&nbsp;</P><P>I have a question that I couln't figure for myself.</P><P>&nbsp;</P><P>I need to set in "DATA_CAPTURA" a specific time like "01/07/2022 to 01/07/2022". but, my "QTD_ATND_2 (it's basically a SUM) "need to be "70".</P><P>If I change my range in "DATA_CAPTURA" to 01/07/2022 to 31/07/2022 I will only get what is beetween this two values. But I need everthing that is before "31/07/2022".</P><P>&nbsp;</P><P><img />&nbsp;</P><P>Best Regards,</P><P>Daniel.</P> Wed, 01 Feb 2023 18:07:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Getting-total-of-a-SUM-based-on-a-specific-data-range/m-p/3055890#M105414 Anonymous 2023-02-01T18:07:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Getting-total-of-a-SUM-based-on-a-specific-data-range/m-p/3055921#M105417 <P>Anonymous</LI-USER>&nbsp;Try this:</P><LI-CODE lang="markup">VAR LastSelectedDate = CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates[Date] ) ) VAR Result = CALCULATE ( [QTD_ATND_2], Dates[Date] &gt; LastSelectedDate ) RETURN Result</LI-CODE> Wed, 01 Feb 2023 18:27:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Getting-total-of-a-SUM-based-on-a-specific-data-range/m-p/3055921#M105417 AntrikshSharma 2023-02-01T18:27:23Z