title: DAX - Calculate counts by using filter on multible columns
body: <p>I am trying to get distinct counts by filters on tabular. Scenaria is like below.</p>
  
  <p><code>
  ID        ¦ProductName          ¦ color
  ----------¦ ------------------  ¦------
   1        ¦Crankarm             ¦    NA
   2        ¦Bearing Ball         ¦ Black
   1        ¦Bearing Ball         ¦ Black
   3        ¦Bearing Ball         ¦ Black
   4        ¦Blade                ¦ Black
   2        ¦Crankarm             ¦ Black
   5        ¦Bearing Ball         ¦ Black
   6        ¦Bearing Ball         ¦ Black
   6        ¦Blade                ¦ Black
   7        ¦Blade                ¦ Black
   7        ¦Blade                ¦ Black
   3        ¦Blade                ¦ Black
   5        ¦Crankarm             ¦ Black
   9        ¦Decal                ¦    NA
  </code></p>
  
  <p>I want to get 3 different Distinct Counts of 'ID'. Filters are like below:
  <code>
   1. ProductName ='Bearing Ball' and Color = 'Black' &gt;(ID=2,1,3,5,6 &gt; Distinct count:5)
   2. ProductName ='Blade'        and Color = 'Black' &gt;(ID=4,6,7,7,3 &gt; Distinct count:4)
   3. ProductName ='Crankarm'     and Color = 'Black' &gt;(ID=2,5 &gt; Distinct count:2)
  </code>
  And will sum all 3 distinct counts. Final result of my measure will be: 5+4+2 = 11.</p>
  
  <p>I calculated measures by below code for all 3 products separetly. And SUM result of 3 measures in a other measure.(FinalResult:= [BB]+[BL]+[CR] ) but it didn't work.</p>
  
  <p><code>BB:= CALCULATE (
      DISTINCTCOUNT ( Product[ID] ),
      FILTER (
          VALUES (Product ),
          Product[ProductName] = "Bearing Ball" &amp;&amp; Product[Color] = "Black"   )
  )
  </code>
  <code>BL:= CALCULATE (
      DISTINCTCOUNT ( Product[ID] ),
      FILTER (
          VALUES (Product ),
          Product[ProductName] = "Blade" &amp;&amp; Product[Color] = "Black"   )
  )
  </code></p>
  
  <p><code>CR:= CALCULATE (
      DISTINCTCOUNT ( Product[ID] ),
      FILTER (
          VALUES (Product ),
          Product[ProductName] = "Crankarm" &amp;&amp; Product[Color] = "Black"   )
  )
  </code></p>
  
  <p>I can't get distinct counts in same query by adding OR because, different ProductName can have same ID. And if use in same query, i will lost them.</p>