title: CALCULATE with OR condition in two tables
body: <p>In order to Sum the sales amount of blue products OR products that belong to category shoes, I'm using the following DAX expression:</p>
  
  <pre><code>CALCULATE(
  
  SUM(Table[SalesAmount]),
  
  FILTER(
  
  Table,
  
  Table[Color] = "Blue" ||
  
  Table[Category] = "Shoes")
  
  )
  </code></pre>
  
  <p>However, this doesn't work with two different tables (Colors and Categories), like:</p>
  
  <pre><code>CALCULATE(
  
  SUM(Table[SalesAmount]),
  
  FILTER(
  
  Table,
  
  Colors[Color] = "Blue" ||
  
  Categories[Category] = "Shoes")
  
  )
  </code></pre>
  
  <p>Can anyone help?</p>
  
  <p>Thanks!</p>