DAX function to search for multiple values in strings and count the number of times each value occur

Hi GSTI08 ,

It is suggested to create another region table by DAX or just enter data.

Region =
DATATABLE (
    "Region", STRING,
    {
        { "Africa" },
        { "South America" },
        { "ME" },
        { "North America" },
        { "UKI" },
        { "Europe" }
    }
)

Then, create measures like what Greg_Deckler provided.

4 CalcRegion = 
VAR __SearchTerms =
    ADDCOLUMNS (
        Regions,
        "Count",
            COUNTROWS (
                FILTER (
                    'Accounts',
                    FIND ( [Region], 'Accounts'[Primary Connectivity Regions],, 0 ) > 0
                )
            )
    )
RETURN
    SUMX ( __SearchTerms, [Count] )

Best Regards,

Icey

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