Filter on Contains but show all

It can be done with the following query.

Notice that the major part of the query takes care of creating blanks in the "Resource" column for repeating resources, so you might want to reconsider this part.

let
    Source = Table.NestedJoin(Table1,{"Project"},Filter,{"Filter"},"Filter",JoinKind.Inner),
    #"Removed Columns" = Table.RemoveColumns(Source,{"Filter"}),
    #"Merged Queries" = Table.NestedJoin(#"Removed Columns",{"Resource"},Table1,{"Resource"},"Table1",JoinKind.LeftOuter),
    #"Removed Columns1" = Table.RemoveColumns(#"Merged Queries",{"Project", "Resource"}),
    #"Expanded Table1" = Table.ExpandTableColumn(#"Removed Columns1", "Table1", {"Project", "Resource"}, {"Project", "Resource"}),
    #"Sorted Rows" = Table.Sort(#"Expanded Table1",{{"Resource", Order.Ascending}, {"Project", Order.Ascending}}),
    #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 0, 1),
    #"Added Index1" = Table.AddIndexColumn(#"Added Index", "Index.1", 1, 1),
    #"Merged Queries1" = Table.NestedJoin(#"Added Index1",{"Index"},#"Added Index1",{"Index.1"},"Previous",JoinKind.LeftOuter),
    #"Expanded Previous" = Table.ExpandTableColumn(#"Merged Queries1", "Previous", {"Resource"}, {"Previous.Resource"}),
    #"Sorted Rows1" = Table.Sort(#"Expanded Previous",{{"Index", Order.Ascending}}),
    #"Added Custom" = Table.AddColumn(#"Sorted Rows1", "Custom", each if [Resource] = [Previous.Resource] then null else [Resource]),
    #"Removed Columns2" = Table.RemoveColumns(#"Added Custom",{"Resource", "Index", "Index.1", "Previous.Resource"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns2",{{"Custom", "Resource"}}),
    #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns",{"Resource", "Project"})
in
    #"Reordered Columns"