Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to figure out how to calculate crime rates within the Power BI Desktop app.
In Excel, it would look like: (Total Amount of Crime ÷ Population * 1,000)
I currently have the following variables:
What I really need is a way to get crime rates for each city and each year for a total of 9 individual crime rates
(e.g. CRID ÷ Location Population for Specific Year * 1,000)
Is there a way to do this??
Hi @Anonymous
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
@Anonymous ,
It would be like
divide(sum(Table1[Total Amount of Crime]),Sum(Table2[Population)) * 1000
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |