Calculate Measure Filter - Only Include Latest Record in RowCount

[elmarcinpbi]

I have a report visual that needs the percentage of people referred to program that actually enrolled in the program.  People can be referred more than once. 

I have this measure but I would only like to restrict it to the latest Disposition date. 

ReferredToH = CALCULATE(COUNTROWS(ProgramDisposition),FILTER(ProgramDisposition,(ProgramDisposition[tkh_DispositionDate]<=LASTDATE('Calendar'[Date])&&[tkh_DispositionDate]>=FIRSTDATE('Calendar'[Date])&&(ProgramDisposition[DispositionTypeValue]=969750000))))

Is there a way to include only the latest occurence of a program disposition in this measure?

Thank you

[v-qiuyu-msft]

Hi @elmarcinpbi,

You can create a measure like below:

Measure= var latest=Calculate(MAX(ProgramDisposition[tkh_DispositionDate]),all(ProgramDisposition))

return

CALCULATE(COUNTROWS(ProgramDisposition), Filter(all(ProgramDisposition), ProgramDisposition[tkh_DispositionDate] =latest))

If the above DAX doesn't work, please share some dummy data and expected results for our analysis.

Best Regards,
Qiuyun Yu

[elmarcinpbi]

Thank you for the response.  I used a table group and a join to get what I needed, but when I have a minute I will test out this syntax.  I appreciate the help.