title: Powerpivot Rankx with multiple filters
body: <p>I want to assign a row number for [Site] after it's filtered based on three simple criteria: whether they have the same [Year], [Identifier], and where the [LeftOrJoined] column is "JOINED". </p>
  
  <p>So I want the [Rank] column below:</p>
  
  <pre><code>[Year] | [Identifier] | [LeftOrJoined] | [Site] | [Rank]
  2012      1             LEFT             A         
  2012      1             JOINED           B         1
  2012      1             JOINED           C         2
  2013      2             LEFT             A
  2013      2             JOINED           B         1
  2013      2             JOINED           C         2
  </code></pre>
  
  <p>The formula I have is:</p>
  
  <pre><code>Rankx(
      filter(table,
          allexcept(table,
                  [LeftOrJoined]="JOINED",[Year]=[Year],
                  [Identifier]=[Identifier])),
                      [Site], ,1,dense)
  </code></pre>
  
  <p>But I get the error: The ALLEXCEPT function expects a table reference expression for argument '2', but a string or numeric expression was used.</p>
  
  <p>I feel I'm making a basic mistake. Any help greatly appreciated!</p>