drill through date range didnt fillter selected MAX Date-1

[Shanvitha_V]

Hi Export Power BI,
I have Date Range slicer 
example:I have selected Date Range 01/01/2023 to 07/01/2023 Then we need display date between 01/01/2023 to 06/01/2023.
because i need always selected MAX date -1
I have create DAX formula 

Value_new = CALCULATE(sum(Tracker[AMount]),DATESBETWEEN(Tracker[DischargeDate],MIN(Tracker[DischargeDate]),MAX(Tracker[DischargeDate])-1))
Its working 100% in summary page.
summary page i am showing column name is: Department    Totalamount
but when i will drill thought  in Details page my date range didnt filetering its showing all records mean 01/01/2023 to 07/01/2023 but drill throught also i need date filter betwen 01/01/2023 to 06/01/2023

Detail page below table date shwoing
PatientID   Dischargedate   admissiondate   col1  col2  col3 col4 col5 col6

but my drill through showing wrong data(betwen 01/01/2023 to 07/012023) but I need display only 01/01/2023 to 06/01/2023

Date range user select dynamic so static.
anybody can help 
Thanks
Shanvitha

[Shanvitha_V]

I have tryied but No lock

[amitchandak]

@Shanvitha_V , if your measure was the reason for filter in the visual. You need use same measure in drill report to get the filter passed

refer to how terminated employee, which was because of measure is used in drill through

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA