title: DAX: distinct count using multiple columns
body: <p>My table includes bunch of duplicated sales information for individual sellers, and I basically created a column and a measure which flags users whether the view they have includes duplicated sales information. </p>
  
  <p>here is a very simplified example of what my table looked like</p>
  
  <pre><code>SalesManager  SalesPersonnel   Acccount   Product  Revenue
  SalesManager1 SalesPersonnel1 Acccount_A Product_A 100000
  SalesManager1 SalesPersonnel1 Acccount_B Product_C 100000
  SalesManager1 SalesPersonnel3 Acccount_A Product_A 100000
  SalesManager2 SalesPersonnel3 Acccount_B Product_C 100000
  SalesManager1 SalesPersonnel2 Acccount_B Product_C 100000
  SalesManager1 SalesPersonnel2 Acccount_B Product_C 100000
  SalesManager4 SalesPersonnel4 Acccount_B Product_A 100000
  SalesManager4 SalesPersonnel4 Acccount_A Product_D 100000
  SalesManager4 SalesPersonnel5 Acccount_A Product_B 100000
  SalesManager4 SalesPersonnel5 Acccount_A Product_A 100000
  </code></pre>
  
  <p>I then created a column </p>
  
  <pre><code>=Acccount&amp;Product&amp;Revenue
  </code></pre>
  
  <p>This is an extremely simplified example, in my real workbook, I have 30+ columns that I have to combine.</p>
  
  <p>and a measure</p>
  
  <pre><code>= if(CALCULATE(DISTINCTCOUNT([ConsldforDupeCheck]))=COUNTROWS(Table),"","*PossibleDoubleCountError*"
  </code></pre>
  
  <p>This has been working quite well, except I found that the calculated column that combines bunch of the columns is causing the file size to double...</p>
  
  <p>the only solution I can think of is if I can move the calculated column into measure, but I cannot think of a way to use distinctcount on multiple columns. </p>
  
  <p>Is this possible?</p>