Count based on two different columns

[JackWren]

Hi everyone, 

First time poster here. I have a table with three different columns

Column 1 is Customer-ID

Column 2 is Country

Column 3 is Region 

I'm trying to count the number of clients for each country's region. 

For example, the result should be that there are 3 customers for Bxl in Belgium, two for Chubu in Japan etc. 

I was thinking about concatenating the two region and country columns into a single column but I think creating a measure might be smarter. I just don't know how to built it to take two different columns into account. 

Do you have any idea how to proceed? 

Thanks

Cust_ID      Pays         Region

1	France	IDF
2	Belgium	WL
3	Belgium	BXL
4	Belgium	BXL
5	Belgium	BXL
6	Belgium	FL
7	Belgium	FL
8	Belgium	FL
9	France	IDF
10	France	IDF
11	France	Occitanie
12	France	Occitanie
13	Japan	Hokkaido
14	Japan	Hokkaido
15	Japan	Hokkaido
16	Japan	Chubu
17	Japan	Chubu

[JackWren]

Hi @themistoklis,

Thank you for your recommandations! I'm going to try the first option.

[themistoklis · Accepted solution]

Hello @JackWren and welcome to the community,

Quick and Easy solution is to create a table add Country, Region and for Cust_ID (select count) 

See image below

If you want to create a measure, then add the following formula

No_of_Customers = COUNT('Table'[Cust_ID ])

or

No_of_Customers = DISTINCTCOUNT('Table'[Cust_ID ])