Sum of Values of minimum date for each group measure

[NirmalRayan]

I found this question in Stack Overflow but it was for SQL query. I would like to know how this can be done in DAX. 

It should be a measure as it should dynamically (should work on filtered data too)  select the minimum date for each group (ID)  and sum the values (WEIGHT) corresponding to it. 

Thanks for the Help. 🙂

[Mariusz]

Hi @NirmalRayan 

Try the below.

Measure = 
SUMX(
    SUMMARIZE( 'Table', 'Table'[ID], 'Table'[DATE] ),
    VAR __minDate = 
        CALCULATE(
            MIN( 'Table'[DATE] ), 
            ALL( 'Table'[DATE] )  
        ) 
    RETURN 
        IF( 
            __minDate = 'Table'[DATE],
            CALCULATE( 
                SUM( 'Table'[weight] ),
                'Table'[DATE] = __minDate 
            )
        )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn