Problem using sumx() with containsstring

Hi CLANG10 ,

is very simple in Power Query using this code

#"Changed Type" = Table.TransformColumnTypes(Facts49_Table,{{"Display ID", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Display ID", Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv), {"Display ID.1", "Display ID.2", "Display ID.3"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Display ID.1", type text}, {"Display ID.2", type text}, {"Display ID.3", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Display ID.1", "Display ID.3"})
in
#"Removed Columns"

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