Parameter

[Syndicate_Admin]

Hello! I have a table that has a number of crimes and some have victims (deaths). I wanted to know how to make a parameter with victims by calculating the average number of crimes for each victim. There may be up to 1-10 victims in a crime, but it doesn't always happen. E.g. each quantos crimes average happens a 1 victim and thus follow up to 10 with the parameter.

[amitchandak]

@Syndicate_Admin , You need a measure like

AverageX(Values(Table[victim]), calculate(Sum(Table[Count of victim])) )

[Syndicate_Admin]

Sorry but it doesn't work for me, I want to do it with a PARAMETER =

Number of Victims = GENERATESERIES(1, 10, 1) every now 1-10 victims will appear for every n crimes (average number of crimes). Ex: One victim will appear every 9000 crimes, two victims in a crime will appear every 12000 crimes, three victims in a crime will appear every 34000 crimes and so on until reaching 10. The victims come from id_tipo 1 = Homicide and id_tipo 2 = Injuries (serious traffic accidents). I hope you have understood me and thank you for taking the time to answer me