LASTDATE Filter issue

[Mrignalini]

I am using below code for calculating a measure which will show the result for the last date selected in the date slicer between filter. 

CALCULATE(DISTINCTCOUNT(processor_management[user_id]) , processor_management[role]  = "Reviewer", Filter(processor_management, LASTDATE(processor_management[updated_at - Date])))

Date slicer is below: 

 the start date - 11/6/2024 

    End date - 11/7/2024

According to the measure, the value should not change if i change the start date keeping the end date same. But the value changes even if i change the start date. 

[FreemanZ · Accepted solution]

hi @Mrignalini ,

try like:

CALCULATE(

    DISTINCTCOUNT(processor_management[user_id]) , 

    processor_management[role]  = "Reviewer", 

    Filter(

        processor_management, 

        processor_management[updated_at - Date] = MAX(processor_management[updated_at - Date])

    )

)

LASTDATE is a time intelligence function, it has many preconditions.