Forum Discussion

elmarcinpbi's avatar
elmarcinpbi
Frequent Visitor
9 years ago

Calculate Measure Filter - Only Include Latest Record in RowCount

 

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

 

Need Help

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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's avatar
      elmarcinpbi
      Frequent Visitor
      9 years ago

      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.