title: How to create a measure in power bi that counts yes and no values based on a country
body: <p>I am new to power bi, i am trying to use &quot;state cards&quot; by okviz to create multiple dynamic cards.</p>
  <p>i have an example of the following data structure: table 1</p>
  <pre><code>Country  | Answer
  Amercica | Yes
  America  | NO
  America  | YES
  America  | Yes
  Brazil   | NO
  Brazil   | NO
  Brazil   | NO
  Brazil   | NO
  Brazil   | yes
  </code></pre>
  <p>how do i create a measure in power bi that counts the yes and no columns per country and gives me the following output</p>
  <pre><code>Country | Answer |count
  America |Yes     |3
  America |No      |1
  Brazil  |Yes     |1
  Brazil  |No      |4
  </code></pre>