Sum of Result of rows from another measure

[Tech122]

Hi, Gurus. Hope you can help me . I have tried hours looking for a solution and tried multiple attempt but failed.
Hope somwone could help me here . I need to show the total, base on the selecttion of date , which is already defined on 01. New measure . Currently its showing the latest dates result set in Total. 

Many thanks in advance

 

[Tech122]

Hi Thanks for this, perhaps if I include the 01. New calculation it might be more understandable .

01.New =

VAR CurrentWeekEnd = MAX( 'Date Slicer'[Week End] )

VAR PreviousWeekEnd = CurrentWeekEnd - 7

VAR NewOpportunityID =

    ADDCOLUMNS(

        ALLSELECTED( 'Snap Week Validation'[Opportunity_SID] ),

        "@FirstDate",

            CALCULATE(

                MIN( 'Snap Week Validation'[Snap_Week_Date] ),

                'Date Slicer'[Date] >= PreviousWeekEnd,

                REMOVEFILTERS(  'Date Slicer' ), REMOVEFILTERS( 'Close Date' )

            )

    )

VAR NewOnes = FILTER( NewOpportunityID, [@FirstDate] = CurrentWeekEnd )

VAR Result =

    CALCULATE(

        [TotalAmount],

        TREATAS( NewOnes, 'Opportunity Detail'[Opportunity_SID], 'Date Slicer'[Date] )

    )

RETURN

    Result
and the output of 01. New is as below when the date selected . But what I need is to show the total in Total row. Thanks 

[vs_7]

Hi  ,check below steps

Create a measure to calculate the total based on the selected date range. Let's assume the measure name is "Total Sales."

• Total Sales = CALCULATE(SUM('YourTableName'[Sales]), 'YourTableName'[Date] IN ALLSELECTED('YourTableName'[Date]))

  Replace 'YourTableName' with the actual name of your table and '[Sales]' with the column name representing your sales.

• Create a visual, such as a card or a table, to display the total sales. Drag the "Total Sales" measure to the values area of the visual.

• Add a date slicer to the report canvas. Drag the "Date" column to the slicer visual.

• Select the desired date range in the slicer. The "Total Sales" measure will dynamically update based on the selected date range.

@Tech122