title: PowerBI - Select last non-blank value of a Measure based on most recent Date
body: <p>I have the following table in PowerBI :</p>
  <pre><code>FullDate              Visits     Orders    ConversionRate
  01/02/2020 00:00:00    100         20           0,20
  01/02/2020 01:00:00    550         78           0,14
  01/02/2020 02:00:00    652         60           0,09
  01/02/2020 03:00:00     0           0           0,00
  01/02/2020 04:00:00     0           0           0,00
  01/02/2020 05:00:00     0           0           0,00
  </code></pre>
  <p>ConversionRate is a measure :</p>
  <pre><code>ConversionRate = DIVIDE(SUM(Table[Orders]),SUM(Table[Visits]))
  </code></pre>
  <p>I need to get the value of  trying to display in a card the latest non-blank value of ConversionRate based on the date.</p>
  <p>I tried this but it returned empty in all the fields :</p>
  <pre><code>LastValue = 
  CALCULATE(
      DIVIDE(SUM([Orders]),SUM([Visits])),
      FILTER(Table, Table[FullDate] = MAX( Table[FullDate] ) &amp;&amp; Table[Visits] &lt;&gt; 0 )
  )
  </code></pre>
  <p>This returned the same value as ConversionRate for each row.</p>
  <pre><code>FullDate              Visits     Orders    ConversionRate   LastValue
  01/02/2020 00:00:00    100         20           0,20          0,20
  01/02/2020 01:00:00    550         78           0,14          0,14
  01/02/2020 02:00:00    652         60           0,09          0,09
  01/02/2020 03:00:00     0           0           0,00          0,00
  01/02/2020 04:00:00     0           0           0,00          0,00
  01/02/2020 05:00:00     0           0           0,00          0,00
  </code></pre>
  <p>What I want is :</p>
  <pre><code>FullDate              Visits     Orders    ConversionRate   LastValue
  01/02/2020 00:00:00    100         20           0,20          0,09
  01/02/2020 01:00:00    550         78           0,14          0,09
  01/02/2020 02:00:00    652         60           0,09          0,09
  01/02/2020 03:00:00     0           0           0,00          0,00
  01/02/2020 04:00:00     0           0           0,00          0,00
  01/02/2020 05:00:00     0           0           0,00          0,00
  </code></pre>
  <p>I am sure I am missing something but I am new to DAX.. Any help would be appreciated</p>