title: Power BI - How can I create a measure aggregation from two tables?
body: <p>I've got two tables Fauna_Afetada (animals affected) e Municipios (all cities of the country). A fauna afetada tem a sigla_uf (state initials which the city belongs to) e nome_municipio (name of the city), as well as the Municipios table.</p>
  <ul>
  <li>I'd like to create a measure counting the number of deaths (Situação_Int = 0 in table Fauna_Afetada, specify that the animal died) by city (table Municipios). The way to join these tables is by using two columns (the sigla_uf and nome_municipio), because each Municipio in Fauna_Afetada might appear several times. How do I do that?</li>
  <li>I'd like to create a measure with the name of the city with the highest number of deaths.</li>
  </ul>
  <p>Anyone could help?</p>
  <p>The data model is below.</p>
  <p><a href="https://i.stack.imgur.com/Y4vwi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y4vwi.png" alt="enter image description here" /></a></p>