title: COUNTIF equivalent in Power BI / DAX?
body: <p>I have the below table and trying to move from excel to Power Bi. In excel I use <code>=COUNTIFS($A$2:$A$16,"&lt;="&amp;E2,$B$2:$B$16,"&gt;="&amp;E2)</code> to get Count value but I wonder how can I calculate it in Power BI</p>
  
  <pre><code>open_date   close_date          Date        Count
  16-Sep-18   14-Jan-19           16-Sep-18   1
  21-Sep-18   19-Jan-19           17-Sep-18   1
  23-Sep-18   21-Jan-19           18-Sep-18   1
  17-Jan-19   27-Jan-19           19-Sep-18   1
  26-Jan-19   28-Jan-19           20-Sep-18   1
  27-Jan-19   28-Jan-19           21-Sep-18   2
  19-Jan-19   19-Jan-19           22-Sep-18   2
  19-Jan-19   29-Jan-19           23-Sep-18   3
  27-Jan-19   29-Jan-19           24-Sep-18   3
  20-Jan-19   30-Jan-19           25-Sep-18   3
  23-Jan-19   30-Jan-19           26-Sep-18   3
  26-Jan-19   30-Jan-19           27-Sep-18   3
  28-Jan-19   30-Jan-19           28-Sep-18   3
  21-Jan-19   31-Jan-19           29-Sep-18   3
  25-Jan-19   31-Jan-19           30-Sep-18   3
  </code></pre>