title: Is it possible to convert DAX functions into a Measure so I can filter with a slicer?
body: <p>I'm just getting my feet wet with DAX and the like, and I know the solution I'm looking for is probably very simple and elegent, but it's at the very edge of my knowledge.</p>
  <p>I really hope you can help me out :)</p>
  <p>The data I'm working with is a large list of claims.</p>
  <p>The data gives a <code>Timestamp</code> when a <code>'Claim ID'</code> is <code>'Ready for Review'</code> and <code>'Complete'</code></p>
  <p>Because the nature of the business, sometimes a claim goes back into <code>'Ready for Review'</code> after it's been 'Complete'ed, so some <code>'Claim ID'</code>s can have multiple lines that are marked <code>'Ready for Review'</code>.</p>
  <p>Right now I have three DAX functions to calculate if a claim is currently <code>'Ready for Review'</code></p>
  <blockquote>
  <p>Columns and such:</p>
  <p><code>RFE State History</code> is the table</p>
  <p><code>Timestamp</code> gives the date and time down to the second</p>
  <p><code>Claim Id</code> is the claim number</p>
  <p><code>Status Label</code> will either be &quot;Ready for Review&quot; or &quot;Complete&quot;</p>
  </blockquote>
  <pre><code>MaxDate: =
  CALCULATE (
      MAX ( 'RFE State History'[Timestamp] ),
      FILTER (
          'RFE State History',
          'RFE State History'[Claim Id] = EARLIER ( 'RFE State History'[Claim Id] )
      )
  )
  </code></pre>
  <p>This filters by claim number, then outputs the latest date of the lot.</p>
  <pre><code>IsLatest: =
  IF('RFE State History'[Timestamp]='RFE State History'[MaxDate],&quot;Latest&quot;)
  </code></pre>
  <p>When the <code>MaxDate</code> value equals the date on this line, output &quot;Latest&quot;</p>
  <pre><code>Ready for Review: =
  IF (
      'RFE State History'[Status Label] = &quot;Ready for Review&quot;
          &amp;&amp; 'RFE State History'[IsLatest] = &quot;Latest&quot;,
      1
  )
  </code></pre>
  <p>When the column <code>IsLatest</code> is &quot;Latest&quot;, output &quot;1&quot;</p>
  <hr />
  <p>I then use 'Redy for Review' in a Pivot Table to sum up how many claims are <code>Ready to Review</code> at that particular moment.</p>
  <p>What I need to do from here:</p>
  <p>I want to be able to use a Slicer to tell how many claims were <code>Ready to Reiew</code> on any particular day in the past (and seperately: in each hour of the day as well so we can track progress throughout the day).</p>
  <p>After Googling about for a couple weeks I ran across these:</p>
  <p>~<a href="https://stackoverflow.com/questions/49015485/is-it-possible-to-use-a-slicer-as-a-parameter-to-a-dax-summarize-function">Is it possible to use a slicer as a parameter to a DAX Summarize function?</a></p>
  <p>~<a href="https://www.youtube.com/watch?v=vQIDJVkFW8o" rel="nofollow noreferrer">DAX Fridays! #93: MAXX | Fill down with DAX and Power Query (YouTube)</a></p>
  <p>~<a href="http://umashanthan.blogspot.com/2017/04/how-to-use-summarizecolumns-function.html" rel="nofollow noreferrer">This blog entry on SUMMARIZECOLUMNS</a></p>
  <p>~<a href="https://community.powerbi.com/t5/Desktop/How-to-use-Summarizecolumns-to-filter-by-Year-and-Description/td-p/133177" rel="nofollow noreferrer">This PowerBI Post on SUMMARIZECOLUMNS</a></p>
  <p>Which leads me to believe I need to write a Measure that basically does the three DAX functions (<code>MaxDate</code>, <code>IsLatest</code>, and <code>Ready for Review</code>) all at the same time using FILTER and SUMMARIZECOLUMNS so they can be filtered with a Slicer.</p>
  <p>Like I said up top there: I'm pretty sure the solution is really simple; I've tried my hand at adapting them to a Measure with no luck. I am only really starting in the DAX world, so I know there's a lot I don't know and don't have a proper grasp on quite yet.</p>
  <p>I am really hoping you can help me out here by pointing me in the right direction.</p>
  <p>Thanks in advance :)</p>