Group

Hi GTL ,

According to your statement, I think you want to combine the data by group like escavators/dirt/dump truck and so on. 

If the group in screenshot above is correct, I think you can remove [Equipment] in your table visual and then Power BI will summarize your data by group in [Dirt] column. Power BI will summarize data if all data are the same, so if you add [Equipment] column into your visual, it will be expanded.

Here I am confused about whether "Escavtor" in "Escavator" group. If yes, it is hard for us to do in Power BI. I think you need to make sure each character contains the complete category word. Then we can use contain dax to create group column.

Group =
SWITCH (
    TRUE (),
    CONTAINSSTRING ( 'Table'[Equipment], "Escavator" ), "Escavator",
    CONTAINSSTRING ( 'Table'[Equipment], "Dump trucks" ), "Dump trucks",
    CONTAINSSTRING ( 'Table'[Equipment], "dirt" ), "Dirt",
    "Others"
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.