Forum Discussion
Parameter
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.
2 Replies
Syndicate_Admin , You need a measure like
AverageX(Values(Table[victim]), calculate(Sum(Table[Count of victim])) )
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
