Add up columns from a related table and find max value

[SimonBE]

Hi Community,

I'm currently working on tables following the same pattern as the two tables below : a table with users and id and another related table with trips linked to users.

I'd like to add a calculated column to the users table that calculates the length of the longest trip for each users, total length being the addition of the "Moving", "Wait" and "Parking" column.

If you could help me doing that, that'd be great !

[jthomson]

Probably easiest to make a calculated column within your trips table just adding each of the three time columns, and then go for a measure that finds the max of that column

[SimonBE]

Yes thats what I'm doing right now but I just feel like 'm not using the full potential of DAX here.

[Zubair_Muhammad · Accepted solution]

@SimonBE

You could use this calculated column as well in the USERS table

length of longest trip =
MAXX (
    RELATEDTABLE ( TripsTable ),
    TripsTable[Moving] + TripsTable[Parking]
        + TripsTable[Wait]
)