Forum Discussion

Annah's avatar
Annah
Regular Visitor
6 years ago
Solved

Need help calculating the Death Rate.

 

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's avatar
    mwegener
    6 years ago

    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.

5 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

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

  • saraMissBI's avatar
    saraMissBI
    Icon for Resolver I rankResolver I
    6 years ago

    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's avatar
      Annah
      Regular Visitor
      6 years ago

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

      • az38's avatar
        az38
        Icon for Community Champion rankCommunity Champion
        6 years ago

        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