Count # of Twitter Followers, given there are duplicate rows

[LyonsBI_BRL]

I'm attempting to calculate the number of Twitter followers per RegistrantID. Each Registrant ID has multiple Rows.

Problem is when I attempt to look at the number of Twitter Followers for each RegistrantID, I'm getting way more than the number of actual Twitter Followers. 

I did try a Measure of

 CALCULATE(MaX('All Applicants'[value.FollowersonTwitter])

Though that didn't seem to help any.

Any suggestions here?

[amitchandak · Accepted solution]

@LyonsBI_BRL , Try a new measure like

MaXX(values('All Applicants'[value.RegistrantID]), calculate(max( 'All Applicants'[value.FollowersonTwitter])))

[LyonsBI_BRL]

@amitchandak that worked great!

Now if I wanted to count words instead of numbers how would I do that instead? I have another column that is called value.State. Which I need to count the number of distinct entries per state. Again I have multiple rows for the same Registrant ID showing up.