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!