topic Re: Computing a sum that depends on the max of other column, which depends on other column in DAX Commands and Tips

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

areiasfi — Wed, 21 Dec 2022 21:56:33 GMT

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!

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

Jihwan_Kim — Thu, 22 Dec 2022 04:24:07 GMT

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] ) ) )

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

areiasfi — Thu, 22 Dec 2022 08:52:53 GMT

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?

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

Jihwan_Kim — Thu, 22 Dec 2022 12:12:14 GMT

Hi,

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