Computing a sum that depends on the max of other column, which depends on other column

[areiasfi]

Hi,

Considering the example:

I would like to compute the sum of timeminutes column for the max value of version column within each idproject column (yellow cells) for each iddate. The result should be the one shown on the right table. What's the best way to do this with dax?

Thank you!

[areiasfi]

Thank you @Jihwan_Kim !

Would this also work if the max depends on more than one column? For example if I need to consider for the max columns idproject, idcampaign, idemployee, etc?

[Jihwan_Kim]

Hi,

Thank you for your message. It works if the additional columns are included inside the measure.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

timeminutes expected result: =
VAR _maxversiontable =
    GROUPBY (
        Data,
        Data[idproject],
        "@maxversion", MAXX ( CURRENTGROUP (), Data[version] )
    )
RETURN
    IF (
        HASONEVALUE ( Data[iddate] ),
        CALCULATE (
            SUM ( Data[timeminutes] ),
            TREATAS ( _maxversiontable, Data[idproject], Data[version] )
        )
    )