title: Calculate distinct of a table column plus two static values using DAX
body: <p>I have a tabular cube that I working on. I would like to get distinct values from &quot;Column1&quot; and then get two additional columns(to be created afresh) as static text one as &quot;All&quot; and other as &quot;2020Q4&quot;.</p>
  <p>Output would look like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column1</th>
  <th>Column2</th>
  <th>Column3</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>AA</td>
  <td>All</td>
  <td>2020Q4</td>
  </tr>
  <tr>
  <td>BB</td>
  <td>All</td>
  <td>2020Q4</td>
  </tr>
  <tr>
  <td>CC</td>
  <td>All</td>
  <td>2020Q4</td>
  </tr>
  <tr>
  <td>DD</td>
  <td>All</td>
  <td>2020Q4</td>
  </tr>
  <tr>
  <td>EE</td>
  <td>All</td>
  <td>2020Q4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Any help is appreciated. So far I am able to get distinct but unable to get associated static values.</p>