title: Need to do Ranking on a measured column in Direct Query mode. Is it possible?
body: <p>Need to do Ranking on a measured column in Direct Query mode. Is it possible? I tried with below, but getting error "Function RANKX is not supported in Direct Query mode".</p>
  
  <pre><code>Rank = IF (
         HASONEVALUE ( Table_Name[ColumnName for which Ranking is required] ), 
  RANKX ( ALL ( Table_Name[ColumnName for which Ranking is required] ), [ColumnName on which Ranking is required])
    )
  </code></pre>