title: What is the DAX equivalent of Row Number() in SQL?
body: <p>I want to add an column in my DAX query output which will give the cumulative row number starting from 1? I want to generate this dynamically for any DAX query that I run. How can I achieve this without much performance impact?</p>
  
  <p>I have a dataset like this:</p>
  
  <p><a href="https://i.stack.imgur.com/LkIyb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LkIyb.png" alt="enter image description here"></a></p>
  
  <p>I have created a measure for ContractValue as SUM([Value]).
  The expected output is to get the dynamic row number generated for the aggregated results as well. For example:</p>
  
  <p><a href="https://i.stack.imgur.com/1obJ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1obJ5.png" alt="enter image description here"></a></p>