title: I need help filtering data that are only available in 2 categories (PowerBI)
body: <p>I have data for hotel rates on 2 different booking channels (Maqam and Maqam Umrah)</p>
  <p><img src="https://i.stack.imgur.com/hfYDd.png" alt="Figure 1" /></p>
  <p>As shown in figure 1, some rates are not available on one booking channel.</p>
  <p>What I want to achieve is to filter only the rates that are available on both booking channels, can anyone help? :)</p>
  <p>Here is the shape of the raw data (Figure 2):</p>
  <p><img src="https://i.stack.imgur.com/HN7Hr.png" alt="Figure 2" /></p>