title: How do I compute distinct count on a column based on a user selection?
body: <p>I have table with millions of rows, and I need to count distinct a column, after eliminating records using a user selection , say a table or slicer..</p>
  
  <p>I tried the function , values  , distinct count .. none of them are working as expected . </p>
  
  <pre><code>unique opners = DISTINCTCOUNT( 'dw useraction_fact'[user_id])
  </code></pre>
  
  <p>I expect to get a distinct count of users acting to a project that I can select, but the distinct count is calculated for each project and it's summed up.</p>