BigQuery: two hitlevel custom dimensions
<p>I can't seem to get a query that gives me all sessions in which customdimensionX has value X and customdimensionY has value Y within the same hit. The query I currently have results in no results found.</p>

<p>Can anybody help me on this:)?
Thanks!</p>

<pre><code>SELECT  sum(totals.visits)

from TABLE_DATE_RANGE([xxxx.ga_sessions_], TIMESTAMP('2016-3-1'),TIMESTAMP('2016-3-1'))

WHERE 
  (hits.customDimensions.index=x AND hits.customDimensions.value='x') 
  AND (hits.customDimensions.index=y AND hits.customDimensions.value='y')
</code></pre>