title: How to remove blank rows in a calculated Power BI table?
body: <p>I have a days to report measure where I perform some calculation on each row for the numerator and then filter out blank rows for the denominator. Example table, code and result as follows:</p>
  
  <pre><code>Team |  Meeting    |  Report
  aaa  | 1/1/2018    |  9/1/2018
  aaa  | 1/1/2018    |  7/1/2018
  bbb  | 1/1/2018    |  1/2/2018
  bbb  | 1/1/2018    | 
  ccc  | 1/1/2018    |  3/3/2018
  aaa  | 1/1/2018    | 
  </code></pre>
  
  <p>This is my function for the average days</p>
  
  <pre><code>CALCULATE(
          AVERAGEX(Planning,Planning[Report]-Planning[Meeting]),
          FILTER(Planning,NOT(ISBLANK(Planning[Report])))
      )
  </code></pre>
  
  <p>And I'd like:</p>
  
  <pre><code>Team | average
  aaa  | 7 (14/2)
  bbb  | 31 (31/1)
  ccc  | 61 (61/1)
  </code></pre>
  
  <p>Function seems to work but I'm slightly paranoid about my (lack of) understanding of CALCULATE and FILTER than I may be doing something wrong?</p>