Finding the average and standard deviation in the counts of specifc events

[RJSuttlemyre]

Hi -- I've searched and tried to find this, but can't seem to figure it out.  Please help!

I am working trying to count categorical variables.  I have a table that has a coulumn named Event Group.  In it, it has a column called "name."  I have figured out how to count the number of occurences of event A with the following:

Count of A =

CALCULATE(COUNTX('DIM-Event Group',COUNT('DIM-Event Group'[Name])),'DIM-Event Group'[Name] = "A")

I now want to calculate the average and standard deviation per month, year, and overall time period for the count of A in this table, but every time I try to use my count measure I get an error telling me it is looking for a column.  

Any suggestions on this?  Thanks!

[amitchandak]

@RJSuttlemyre , Try a measure like

Countrows(Summarize(Filter('DIM-Event Group','DIM-Event Group'[Name] = "A"),'DIM-Event Group'[Name]))

[RJSuttlemyre]

Thanks for the reply -- I really appreciate it.

I tried it and it compiles, but gives the answer of 1 in line chart or column chart, as well as a table.

Did I do something wrong?