title: distinct count of values only one time using dax
body: <p><a href="https://i.stack.imgur.com/dM6He.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dM6He.png" alt="enter image description here" /></a></p>
  <p>i have calculated distinct count of vehicles</p>
  <pre><code>calculate(distinctcount(vehicle number), filter(table1, table1[panel damage severity]=&quot;Major repair&quot;)) 
  
  calculate(distinctcount(vehicle number), filter(table1, table1[panel damage severity]=&quot;Moderate repair&quot;)) 
  
  calculate(distinctcount(vehicle number), filter(table1, table1[panel damage severity]=&quot;Minor repair&quot;)) 
  </code></pre>
  <p>every time it is giving me 1 ,1 ,1 in measure.
  my output is -once the vehicle is counted for &quot;Major repair&quot; it should not count for &quot;Moderate repair/Minor repair&quot;</p>
  <p>and if vehicle is counted for &quot;Moderate repair&quot; it should not count for Minor repair.</p>
  <p>Major repair&gt; Moderate repair&gt; Minor repair</p>
  <p>so here the output I want</p>
  <pre><code>Major repair vehicles = 1
  Moderate repair vehicles = 1
  Minor repair vehicles = 0
  </code></pre>
  <p>pls help me. thanks in advance.</p>
  <pre><code>Vehicle Number panel Damage Severity 
  85BHF                 Minor repair 
  85BHF                 Minor repair 
  85BHF                 Moderate repair 
  85BHF                 Minor repair 
  85BHF                 Major repair 
  
  85BHF                Minor repair 
  85BHF                Major repair 
  415TPI               Minor repair 
  415TPI               Moderate repair 
  415TPI                Minor repair 
  415TPI                Minor repair 
  415TPI                Minor repair 
  415TPI                Minor repair 
  415TPI               Minor repair 
  415TPI               Minor repair
  </code></pre>