Calculate the Start date Amount of ids within a date range

[TEACHY888]

Hi , I am new on DAX and need some help here. 

I need to sum the Start Date (Min date ) Amount of IDs with in a selected date range. I have tried chatGPT and it has provided me this : 

VAR StartDate = MIN(OpportunityOldValue_NewValue[changed_date])

VAR EndDate = MAX(OpportunityOldValue_NewValue[changed_date])

RETURN

    SUMX(

        VALUES(OpportunityOldValue_NewValue[opportunity_Sid]),

        CALCULATE(

            SELECTEDVALUE(OpportunityOldValue_NewValue[old_amount]),

            FILTER(

                OpportunityOldValue_NewValue,

                OpportunityOldValue_NewValue[changed_date] = MAX(OpportunityOldValue_NewValue[changed_date]) &&

                OpportunityOldValue_NewValue[changed_date] >= StartDate &&

                OpportunityOldValue_NewValue[changed_date] <= EndDate

            ),

            OpportunityOldValue_NewValue[changed_date] = StartDate

        )

    ), the code works for individual IDs but when I want to visualse in a graph or table the Total amount is blank.

Would be great if someone could look into this , many thanks in advance 

[amitchandak · Accepted solution]

@TEACHY888 , this happens when row context has been used.

Assume your current measure name is Pipeline start

create a new measure like

Sumx(Summarize( OpportunityOldValue_NewValue, OpportunityOldValue_NewValue[opportunityid],OpportunityOldValue_NewValue[changed_date], "_1", [pipeline start]) , [_1])

[TEACHY888 · Accepted solution]

@amitchandak , Mnay thanks for your input, it works 👍

[amitchandak · Accepted solution]

@TEACHY888 , this happens when row context has been used.

Assume your current measure name is Pipeline start

create a new measure like

Sumx(Summarize( OpportunityOldValue_NewValue, OpportunityOldValue_NewValue[opportunityid],OpportunityOldValue_NewValue[changed_date], "_1", [pipeline start]) , [_1])