Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |