Create new column. Current column has values separated by a semicolon and hashtag

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new table.

Desired table = 
VAR _newtable =
    ADDCOLUMNS ( Data, "@new", SUBSTITUTE ( Data[Program], ";#", "|" ) )
VAR _separate =
    ADDCOLUMNS (
        _newtable,
        "@first", PATHITEM ( [@new], 1 ),
        "@second", PATHITEM ( [@new], 2 ),
        "@third", PATHITEM ( [@new], 3 ),
        "@fourth", PATHITEM ( [@new], 4 )
    )
VAR _finaltable =
    UNION (
        SUMMARIZE ( _separate, [@first], Data[Count] ),
        SUMMARIZE ( _separate, [@second], Data[Count] ),
        SUMMARIZE ( _separate, [@third], Data[Count] ),
        SUMMARIZE ( _separate, [@fourth], Data[Count] )
    )
RETURN
    GROUPBY (
        FILTER (
            SELECTCOLUMNS (
                _finaltable,
                "@Program unique", [@first],
                "@Count", Data[Count]
            ),
            [@Program unique] <> BLANK ()
        ),
        [@Program unique],
        "Count", SUMX ( CURRENTGROUP (), [@Count] )
    )