Sumar filas

Hay @Syndicate_Admin @Alberto_O

No está muy claro, el total se basa actualmente en la fecha de equipo y fecha de salida, puede hacer M o DAX. ¿Qué sucede si desea calcular diferentes condiciones? ¿Y quieres una medida o una columna calculada?

M

let
  Source = Table.FromRows(
    Json.Document(
      Binary.Decompress(
        Binary.FromText(
          "nZCxCoNAEER/JVwtuLsTCbFLvsAinVgcKmmMNv4/4XBhT9fKbnkwj9lp2/DhUIRmivMa0/WafrEf53QSl4RSSPhGUtMBMW2IKwpdoZ4sbco8xDXTAT3VcxfzuD6SQmJ9oH0MsVYU9n1k3ycLQfsYkjOPhd/LMH43Dfw8O4SEHiaxaD4y/FO4MjL8yDgfufsD",
          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
      ]
  ),
  #"Changed Type" = Table.TransformColumnTypes(
    Source,
    {
      {"Team", type text},
      {"Origin", type text},
      {"Destination", type text},
      {"Departure Date", type datetime},
      {"Arrival Date", type datetime},
      {"Distance kms", Int64.Type}
    }
  ),
  #"Inserted Date" = Table.AddColumn(
    #"Changed Type",
    "Date",
    each DateTime.Date([Departure Date]),
    type date
  ),
  #"Grouped Rows" = Table.Group(
    #"Inserted Date",
    {"Team", "Date"},
    {{"Total", each List.Sum([Distance kms]), type nullable number}}
  ),
  #"Merged Queries" = Table.NestedJoin(
    #"Grouped Rows",
    {"Team", "Date"},
    #"Inserted Date",
    {"Team", "Date"},
    "Grouped Rows",
    JoinKind.LeftOuter
  ),
  #"Expanded Grouped Rows" = Table.ExpandTableColumn(
    #"Merged Queries",
    "Grouped Rows",
    {"Origin", "Destination", "Departure Date", "Arrival Date", "Distance kms"},
    {"Origin", "Destination", "Departure Date", "Arrival Date", "Distance kms"}
  )
in
  #"Expanded Grouped Rows"

Medida DAX con una columna [Fecha] agregada

Total2 = 
SUMX(FILTER(ALL('Table'),'Table'[Team]=SELECTEDVALUE('Table'[Team])&&'Table'[Date]=SELECTEDVALUE('Table'[Date])),'Table'[Distance kms])

No@Syndicate_Admin,