title: Distinct count on multiple columns - ssrs report
body: <p>I am new to ssrs and I am working on a report where I need to get a distinct count on two columns to display the total.</p>
  
  <p>Table/Dataset format:    </p>
  
  <pre><code>ID   CREATEDATE  
  123  03/01/2015 11:20 pm  
  123  03/01/2015 11:20 PM  
  123  NULL  
  123  03/20/2015 05:15 PM  
  345  04/01/2015 05:20 PM  
  </code></pre>
  
  <p>Datatypes:  </p>
  
  <pre><code>ID - Int  
  CreateDate - Datetime
  </code></pre>
  
  <p>If I get a distinct count on the above ex it should return 3 - First two rows have the same ID and Datetime. Eliminate Null records from the count</p>
  
  <p>I tried something like following it works in all scenarios except when there is null value in a row it shows #error in the output.  </p>
  
  <blockquote>
    <p>=CountDistinct((Fields!ID.Value)+(Fields!CREATEDATE.Value.ToString()))</p>
  </blockquote>
  
  <p>Could anyone please suggest either how to eliminate null value in my distinct count or better way to do this. Appreciate your time and help.</p>
  
  <p>Thanks</p>