title: DAX - Measure count active products
body: <p>Tried a lot but didn't get any expected result.</p>
  
  <p>I need a DAX measure which shows me the second result:</p>
  
  <p>Based on my 2 tables, I need to know how many products is active if they appear in the second table - then 1, else 0</p>
  
  <pre><code>Product1
  A
  B
  C
  D
  E
  F
  
  
  Product2
  A
  J
  K
  A
  B
  J
  F
  F
  F
  </code></pre>
  
  <p>The result should be:</p>
  
  <pre><code>Product Measure
  A   1
  B   1
  C   0
  D   0
  E   0
  F   1
  </code></pre>
  
  <p>Count: 3</p>