Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count of countries

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

Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 
    Add a measure

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

     

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        aj1973
        Community Champion
        5 years ago

        Hi Anonymous 
        Add a measure

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