title: Created table in DAX, but can't extract the correct value
body: <p>I'm attempting to create a measure to give me the rank of a Salesman by Sales.  I'll use the measure in a table where one of the columns is Salesman, so there should be the appropriate row context applied.  But using
  RETURN Calculate( MAXX (RankTable, [Rank] ) )
  just gives me a value of 1 for every broker.  I can't figure out what to used to just pull out the value for Rank calculated in RankTable.  How do I do that?</p>
  <pre><code>SumSales = sumx( SalesData, [Sale])
  ----------
  SalesRank = 
  VAR SummaryTable = 
      ADDCOLUMNS(
          SUMMARIZE( SalesData, [Salesman] ),
          &quot;Sales&quot;, [SumSales]
      )   
  VAR RankTable = 
      ADDCOLUMNS(
          SummaryTable,
          &quot;Rank&quot;, RANKX( SummaryTable, [Sales])
      )
  RETURN 
      Calculate( MAXX (RankTable, [Rank] ) )
  </code></pre>
  <p>I know that RankTable is correct, since DAX Studio give me this result:</p>
  <p>Salesman  Sales   Rank</p>
  <p>A   907 1</p>
  <p>B   600 3</p>
  <p>C   900 2</p>
  <p>D   500 4</p>
  <p>Here's code for measure mentioned in comments:</p>
  <pre><code>Priced. = 
  COUNTROWS(
      FILTER( 'Cases',
          [Date Initiated] &gt;= [MinDate]
          &amp;&amp; [Date Initiated] &lt;= [MaxDate]
          &amp;&amp; not ISBLANK( [Date To Pricing] )
      )
  )
  </code></pre>