title: Is it possible to insert 'null' or blank values where certain 'piars' of values already exist using DAX in Power BI?
body: <p>I am using this:</p>
  <pre><code>'Total = SUMX(
  FILTER(
      Table1,
      Table1[Client] = EARLIER( Table1[Client] )
  ),
  Table1[Sales])'
  </code></pre>
  <p>In the table I have many results that are duplicated in the column created here, I still have a use for the value but I want a way to possibly insert 'nulls' or blanks in instances where 'Client/Sales' pairs (across the rows) are already accounted for. Is there a way to take both columns and when an instance is 'repeated' to insert a blank?
  This is what things look like now...</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client</th>
  <th>Sales</th>
  <th>Total</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1hk4</td>
  <td>4</td>
  <td>8</td>
  </tr>
  <tr>
  <td>1hk4</td>
  <td>2</td>
  <td>8</td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td>3</td>
  </tr>
  <tr>
  <td>5t23</td>
  <td>3</td>
  <td>5</td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td>3</td>
  </tr>
  <tr>
  <td>1hk4</td>
  <td>2</td>
  <td>8</td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td>3</td>
  </tr>
  <tr>
  <td>5t23</td>
  <td>2</td>
  <td>5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is what I'm trying to go for:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client</th>
  <th>Sales</th>
  <th>Total</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1hk4</td>
  <td>4</td>
  <td>8</td>
  </tr>
  <tr>
  <td>1hk4</td>
  <td>2</td>
  <td></td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td>3</td>
  </tr>
  <tr>
  <td>5t23</td>
  <td>3</td>
  <td>5</td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td></td>
  </tr>
  <tr>
  <td>1hk4</td>
  <td>2</td>
  <td></td>
  </tr>
  <tr>
  <td>4f33</td>
  <td>1</td>
  <td></td>
  </tr>
  <tr>
  <td>5t23</td>
  <td>2</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The reason I'm trying for this is because in the report I am unable to turn off summarize and the data doesn't relay well. Ideally I want to be able to see the unique result by client.</p>