Max of date for each customer with date slicer

[ask_kumar]

I have a dataset like below

I have a date slicer aswell

My requirement is to get the max of date for every name when slicer is selected aswell.

I was able to get the max of date without slicer but when slicer is selected my logic is not working

CALCULATE(MAX(Orders[Date]), ALLEXCEPT(Orders,Orders[Name]))

but this logic not working when date slicer is active.

I need as below

a  10/1/2023
b  8/28/2023
c  6/15/2023

if slicer is selected for 9/30/2023, I need as below

a  9/1/2023
b  8/28/2023
c  6/15/2023

Any help is appretiated

[amitchandak]

@ask_kumar , Try a measure like

calculate( max(Orders[Date]), filter(all(Orders), Orders[Name] = max(Orders[Name])))

or

calculate(lastnonblankvalue(Orders[Date], max(Orders[Date])), filter(all(Orders), Orders[Name] = max(Orders[Name])))