Forum Discussion
Crime Rate Calculation Help!
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 follow...
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.