Power Pivot: Relationship does not hold any data because it needs to be recalculated
<p>I have a relationship between a <code>Table1</code> table and a <code>Calendar</code> table.</p>

<p>When I try to use a DAX expression using fields from these table, I get this error:</p>

<p>The expression referenced a relationship between <code>Table1[DateKey]</code> and <code>CalendarTable[DateKey]</code>, which does not hold any data because it needs to be recalculated. </p>

<p>Any ideas of why this is happening?</p>