Measure Development Help Needed: Incident Rate per 100 - Example Data (xlsx) Attached

[neil37]

Hello, 

I am trying to develop a measure that enables me to calculate the crime rate for data that is organized like the attached example data set per 100 students. 

We have 10 years of data of incidents occurring in ~200 schools.

Each year there is a different enrollment number of students 

Each year, various incidents occur within each school

I need your help developing a measure that would enable me to calculate the rate of incidents occurring in each school, per incident, per 100 students (i.e. 36.9 out of every 100 students experienced some sort of incident).

I have splicers with Academic Year and Incident Type to break that rate down further for specific Years and Incident types. I just need help writing a measure that accurately calculates the rate utilizing the data within the attached sheet. 

School Name	School Number	Enrollment AY2009-2010	Enrollment AY2010-2011
School Name 1	1	261	189
School Name 2	2	298	349
School Name 3	3	346	160
School Name 4	4	335	105
School Name 5	5	292	220
School Name 6	6	216	125
School Name 7	7	312	117
School Name 8	8	325	179
School Name 9	9	180	323
School Name 10	10	142	127
School Name 11	11	318	84
School Name 12	12	244	266
School Name 13	13	349	154

School Number	Incident Type	AY
7	Assault	20102011
10	Robbery	20102011
7	Harassment	2011-2012
12	Assault	2013-2014
13	Threat - Verbal	20102011
7	Disorderly Conduct	20102011
5	Assault	2011-2012
1	Robbery	2013-2014
6	Harassment	20102011
5	Assault	20102011

[AlB]

Hi @neil37

Where is the data for the number of incidents?? Please show (an exaple of) the expected result based on the data provided

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[neil37]

Hi @AlB  - For some reason it is not allowing me to post my clarification response, so I had to take a screenshot of it...