title: DAX options to filter 1 side on 1:M relationship
body: <p>I have salesman dimension and sales fact with 1:M relationship on salesman_id.</p>
  <p>I am trying to create a measure for count of salesman that have made sales in location is 6.</p>
  <pre><code>CALCULATE (
        DISTINCTCOUNT ( Salesman[SalesmanKey] ),
        Sales,
        Sales[LocationId] = 6
  )
  </code></pre>
  <p>I think this is not working because the filter doesn't flow from sales into salesman table.</p>
  <p>I could change the filter direction as both but I'm looking at other option like using DAX CALCULATE with CROSSFILTER. Is there any other option like using CALCULATETABLE?</p>