Count of countries

[Anonymous]

Hi guys!

I have a table of around 4000 rows. 

Each row has a country name: 

I would like to display a diagram, showing the counts of each country. 

Could you help me, please? 

Best wishes,

Alisa

[Fowmy]

@Anonymous 

Insert a table visual and drag and drop the country field twice then select the 2nd country field and select the aggregation as Count

Example:

[Anonymous]

@Fowmy thanks. But unfortunately, I don't have options as you have: "don't summarise", "first", "last".... "count"... 

I want to make a diagram, not a table

How can I add them? 

[aj1973 · Accepted solution]

Hi @Anonymous 
Add a measure

Count of countries = COUNT('Table'[Countries])