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?    Bes...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 
    Add a measure

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

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper 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
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hi Anonymous 
      Add a measure

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