Sumar filas

No hay @Syndicate_Admin

Agregue una columna personalizada en M para determinar primero el mismo viaje

let
  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rZHBCsIwEER/RXIudHdWEXvTL+jBW+khaPFS68X/R0IDmzQpSMhtGZjh7cwwmDubxvSzXb7WXdf5bR/T4k7ilqQFgQ+EjjYS0yrxiczY+JzArZGhiTumjXTxOUdoTsIDZ4LyiOdRiT0iOOVBzBOYxPOohFyOmm+f5/RaYyStJ5LESWcNUWtYsqRPSUnJkpYs+yUjV3LB6Kg0epanYHSYOqPH5sLRUWn0/ZL/H338AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Team = _t, Origin = _t, Destination = _t, #"Departure Date" = _t, #"Arrival Date" = _t, #"Distance kms" = _t]),
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    #"Grouped Rows" = Table.Group(#"Added Index", {"Team"}, {{"allrows", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddColumn([allrows],"Trip", (IT)=> 
if IT[Origin] = "Planta1" then IT[Index]
else List.Max( Table.SelectRows([allrows],  each [Index] <IT[Index] and [Origin]="Planta1")[Index]))),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"Team", "Origin", "Destination", "Departure Date", "Arrival Date", "Distance kms", "Trip"}, {"Team", "Origin", "Destination", "Departure Date", "Arrival Date", "Distance kms", "Trip"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Custom",{{"Distance kms", Int64.Type}})
in
    #"Changed Type"

a continuación, una columna DAX o una medida en un objeto visual a su elección, aquí hay una columna DAX

Column = 
VAR CurTrip = [Trip]
RETURN
SUMX(FILTER(Query1,[Trip]=CurTrip),[Distance kms])