Need to group category values

Hi Anonymous ,

Please try below steps:

1. create two measure with below dax formula

Measure =
VAR cur_dk =
    SELECTEDVALUE ( 'Table'[DriverKey] )
VAR cur_city =
    SELECTEDVALUE ( 'Table'[ShipCity] )
VAR tmp =
    FILTER (
        ALL ( 'Table' ),
        'Table'[DriverKey] = cur_dk
            && 'Table'[ShipCity] = cur_city
    )
RETURN
    SUMX ( tmp, [Geo Stop Count] )

Measure2 =
VAR cur_dk =
    SELECTEDVALUE ( 'Table'[DriverKey] )
VAR cur_city =
    SELECTEDVALUE ( 'Table'[ShipCity] )
VAR tmp =
    FILTER (
        ALL ( 'Table' ),
        'Table'[DriverKey] = cur_dk
            && 'Table'[ShipCity] = cur_city
    )
RETURN
    SUMX ( tmp, [Duration] )

2. add a table visual with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.