Create a table that sums multiple columns according to a value

Hello everyone,

I'm pretty new to PowerBI and I've been looking at my issue in this forum, but I'm not sure to find the right case.

I'm trying to vizualize with a map the number of marketing activity that I run through regions:

So the table I want to get is the following:

What I've tried to do on my main table is to create a column per region that put a "1" when a region is mentionned:

I've used this formula for that:

Grand Est = IF(SEARCH("Grand Est",[Zone],1,0)>0,1,0)​

Now I'm trying to generate a new table with the summary of all the regions with the total of activities run, but I'm struggling to get the right formula for that

What I'm looking for is an equivalent of the "countif" function that checks what is the value in the first column and sums only if it matches the text. I've tried: 

Sum = calculate(sum('05 - Agences'[Grand Est])+sum('05 - Agences'[Bretagne])+sum('05 - Agences'[Normandie]),ALLEXCEPT(Region,Region[Région]))

But instead of getting "Bretagne" | 3, I get the sum of all the regions for all the lines.

Hope my explanations were clear enough, Enligsh isn't my native langage. Maybe my initial idea to create new columns with 1 and 0 was not the right way to do, I'm looking forward to get your feedbacks 🙂

Thanks a lot,

Mathieu