Need help calculating the Death Rate.

[Annah]

I need to divide the deaths by population(pop) to get the Death Rate for that Disease and year. Population for the same year is repeted 10 times because the diseases/causes are 10  different diseaseas.  How can I achieve this? Please help.

[mwegener · Accepted solution]

Hi @Annah ,

try this.

Population = SUMX(SUMMARIZE('Table','Table'[Year_State],"@Pop",AVERAGE('Table'[Pop])),[@Pop])

Death Rate = DIVIDE(SUM('Table'[Deaths]),[Population])

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[saraMissBI]

Hi @Annah ,

You can simply create a new calculated column "Death Rate", and put in the formula: 

Death Rate = 'Table'[Deaths] / 'Table'[Pop]

Then specify the format of the new column as percentage

Please give kudos if my answer helps, and mark as a solution if it resolves the issue 🙂

[Annah]

Hello, I have already used that calcuation but it did not resolve  the issue. Thank you anyway. I appreciate your help

[az38]

@Annah you are already have the column Deathrate in your model. Whats exactly wrong with it?

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

You mean to say whatever popullation is showing is correct. If yes then add below measure

Rate=Divide(Deaths,Poppulation,Blank())