Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RJSuttlemyre
Frequent Visitor

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

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!
2 REPLIES 2
amitchandak
Super User
Super User

@RJSuttlemyre , Try a measure like

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

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?

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.