title: Based on a value show different message
body: <p>Follow Up :</p>
  <p>I have these two tables that are mutually exclusive (not connected in any way) .</p>
  <p>The first table has date , number of customers on the dayDISTINCTCOUNT(sales[user_name]), total sales , tier (text - will explain)</p>
  <p>The second table is CustomerLimit which is basically consecutive numbers between 1 and 100.</p>
  <p>Used the tier measure as the answer below (thank you)</p>
  <p>Tier =
  VAR Limit = SELECTEDVALUE ( CustomerLimit[CustomerLimit] )</p>
  <p>VAR CustCount = COUNT ( Customers[CustomerID] )</p>
  <p>RETURN</p>
  <p>IF (</p>
  <p>ISBLANK ( Limit ), &quot;Select a value&quot;,</p>
  <p>IF ( CustCount &gt; Limit, &quot;Good&quot;, &quot;Bad&quot; )</p>
  <p>)</p>
  <p>Now I need to aggregate the total amount of customers by Tier.
  I used
  calculate(DISTINCTCOUNT(sales[user_name]),Tier = &quot;Good&quot;) .</p>
  <p>It give me an error of : A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.</p>
  <p>Is that possible ?</p>
  <p><a href="https://i.stack.imgur.com/r808p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r808p.png" alt="enter image description here" /></a></p>