Sum the Max within a grouped value

[Anonymous]

Hi there,

I'd like to calculate the following in a measure (see screenshot):

[Anonymous · Accepted solution]

Hi @Anonymous ,

Check the measures as below.

Measure = 
var max_date = CALCULATE(MAX('Table'[date]),ALLEXCEPT('Table','Table'[plantid]))
return
IF(SELECTEDVALUE('Table'[date])=max_date,SUM('Table'[value]),BLANK())

Measure 2 = SUMX('Table',[Measure])

Best Regards,

Jay

[mahoneypat]

Here is a measure expression that should work.

RecentValue =
VAR vLastValue =
    SUMX (
        VALUES ( T1[PlantID] ),
        CALCULATE (
            LASTNONBLANKVALUE (
                T1[Date],
                AVERAGE ( T1[Value] )
            )
        )
    )
RETURN
    IF (
        OR (
            NOT (
                HASONEVALUE ( T1[PlantID] )
            ),
            MAX ( T1[Date] )
                = CALCULATE (
                    MAX ( T1[Date] ),
                    ALLSELECTED ( T1[Date] )
                )
        ),
        vLastValue
    )

Pat

[Anonymous]

Hi there, thanks for your support.

Unfortunately, it does not the trick.

It shows me 15 on all rows where plantid is 456. I only want to see it on the row where the modification date = max date.