title: DAX "multiple columns" error when trying to return the Nth ranked text value
body: <p>I was working on a solution to calculate something similar to Qlikview's FirstSortedValue in DAX for Power BI.</p>
  
  <p>To my knowledge, there is no solution out of the box to get the functionality of getting a text value (much like the category) which by its rank is in an nth position.</p>
  
  <p>My question is:
  Why does this work on a single column, but returns a multiple column error when used on a table?</p>
  
  <pre><code>CALCULATE (
      SAMPLE (
          1,
          FILTER (
              'table_name',
              RANKX (
                  ALL ( 'table_name'[column_name] ),
                  CALCULATE ( COUNT ( 'table_name'[column_name] ) ),
                  , , SKIP
              )
                  = Nth
          ),
          TRUE ()
      )
  )
  </code></pre>
  
  <p>a different variation as well:</p>
  
  <pre><code>CALCULATE (
      SAMPLE ( 1, VALUES ( 'table_name'[column_name] ), TRUE () ),
      FILTER (
          'table_name',
          RANKX (
              ALL ( 'table_name'[column_name] ),
              CALCULATE ( COUNT ( 'table_name'[column_name] ) ),
              , , DENSE
          )
              = Nth
      )
  )
  </code></pre>
  
  <p>Both of these and many more of my attempts work when it is a single column, but why would this not work when used on a table with multiple columns? It should return a sample of 1 text value according to the Nth rank I choose?
  Akin to answering a question of "What is the Nth top selling product name according to salescount?".</p>
  
  <p>I am stumped, still trying to find an answer. Firstnonblank is not an option, because I do not care for a solution to get the 1st ranked answer only; do not suggest that.</p>