Measure to count the # rows in each category

[smmoore34]

I have a table with a column heading Munipality  and colums with the address.

I want to have a measure that gives me the # addresses per muncipality.

Here is a screenshot: 

[Anonymous]

@smmoore34  Do one of these solutions accomplish what you're looking to?

[smmoore34]

Exactly!  Unfortunatley I still received the same results. 

[Anonymous · Accepted solution]

@smmoore34  It looks like you created a new table and I'm not sure if you have to, and it looks like the relationship between the new table and existing isn't working. Also, I edited my response and added a second solution that counts the number of cities per municiplaity.

[jdbuchanan71]

Add Municipality to a table visual along with this measure.

Address Count = DISTINCTCOUNT ( 'YourTable'[Address Field] )

[smmoore34]

Worked perfectly when I created it as a measure and added it to a table. 

Thank-you! Happy New Year!

[Anonymous]

You're welcome, and Happy New Year to you too!

[smmoore34]

Thank you for your quick response. As I understand this, I created another table with just the municipalites.

I added a new column with the formula you listed but it's giving me the total# records. My first table has 42 records and each record contains contains 1 of the 9 municipalites. For example, 5 records contain Town of Newfield, 7 contain Town of Groton etc.  My table should show this count for each municipality.