title: Power BI - Dynamic rank leads to cartesian when second table added to table visualization
body: <p>Power BI Desktop Version: 2.97.861.0 64-bit (September 2021)</p>
  <p>I am attempting to create a dynamic rank in a table visualization of a Power BI Report that recalculates based on the filter the user applies</p>
  <p>This is my current DAX formula…</p>
  <pre><code>Rank = 
  VAR v_rank =
  
  RANKX(
      ALLSELECTED('cust_income'),
      CALCULATE(SUM('cust_income'[Income])),
      ,
      DESC,
      Dense
      )
  
  RETURN  
  v_rank
  </code></pre>
  <p>Screenshot below is filtered for Customer ID = 1</p>
  <p>The rank works as expected - it is specific to the Customer ID = 1 records</p>
  <p>HOWEVER - as soon as I add <code>Product Desc</code> to the table visualization, I see the strange cartesian result on the right…</p>
  <p><a href="https://i.stack.imgur.com/hiqPd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hiqPd.png" alt="cartesian" /></a></p>
  <p>There are only two tables. The relationship is a very basic 1:N using <code>Product Code</code>...</p>
  <p><a href="https://i.stack.imgur.com/YjA14.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YjA14.png" alt="erd" /></a></p>
  <p>How to keep <code>Product Desc</code> in my table visualization but eliminate the nonsensical rows that have no <code>Income</code> value?</p>
  <p>Thank you for your insights</p>