title: Measure inside Calculated Column; but measure depends on slicer selection
body: <p>I have a tricky situation in Microsoft Power BI, and DAX language:</p>
  <p>I am developing a new Calculated Column called Status_CC in a table called Customers; we refer to this formally as -  Customers[Status_CC].</p>
  <p>This calculated column (Customers[Status_CC]) has a number of conditions in its derivation, I am using SWITCH statement to develop it.</p>
  <p>i.e.</p>
  <pre><code>Status_CC = SWITCH(
  
                       TRUE(),
  
                       .........
  
                     )
  </code></pre>
  <p>One of the conditions to develop the this Customers[Status_CC] calculated column is:  <strong>Customers[HireDate] &gt; [BonusDate]</strong>.</p>
  <p>The intersting part is, <strong>HireDate is an existing column</strong> in the Customers table.</p>
  <p>However, <strong>[BonusDate] is a measure</strong>; this measure is developed using another table called WorkHistory.</p>
  <p>A column (called PayCategory) from the WorkHistory table acts as a slicer in the report visual. The PayCategory column determines the value of the [BonusDate] measure.</p>
  <p>I am using the DAX function ALLSELECTED on the slicer - the WorkHistory table's PayCategory column, to develop the [BonusDate] measure.</p>
  <p><strong>My question is, will the calculated column Customers[Status_CC] work correctly, if it depends on the [BonusDate] measure, which in turn depends on another table WorkHistory, which feeds PayCategory that acts as a slicer ?</strong></p>
  <p>I don't see any syntax error in Customers[Status_CC], but not sure whether the numbers are right.</p>
  <p>My final report visual in Power BI Report View has:</p>
  <p>-several columns from the Customers table, including the calculated column Customers[Status_CC]</p>
  <p>-a slicer with PayCategory from the WorkHistory table that dictates the value of the [BonusDate] measure.</p>
  <p>Any advice, please?</p>