Calculation Groups not able to filter date column

[rnori_skyline]

I have around 9 measures and i have date buckets "1-30","31-60","61-90","1-120","Last Year","This Week","This Month" date buckets. So i simplified the effort by creating calculated measures using calculation groups. Below is the sample code for one of the calculation item "1-30":

VAR Beg = [Selected  Date] - 30
VAR Last = [Selected  Date] - 0
RETURN
CALCULATE (
SELECTEDMEASURE (),
FILTER (
'Date',
'Table'[Date] > Beg
&& 'Table'[Date] <= Last
)
)

So I have a drill through report which would give details of my parent report,The problem I am facing is that when I drill through from my parent report report to child report, for eg., on 1-30 column from my matric report, I expect the date range in child report in that 30 days range..However, the child report is showing all the dates, which means these calculation groups has not impact on date column on which these are based out of.

Attaching the screenshots of parent and child reports and highlighted the column in child report that is having issue of pulling all the dates (highlighted in yellow):

Parent Report:

Child Report:

[v-luwang-msft]

Hi @rnori_skyline ，

Share your pbix file on a public link ,then attch the link on the case.

Best Regards

Lucien

[v-luwang-msft]

Hi @rnori_skyline ,

Could ypu pls share your pbix file and remember to remove confidential data.

Best Regards

Lucien

[rnori_skyline]

There are two things i am struggling with:

1) How do i attach a PBIX file? I dont see an option anywhere

2) How do i change my email address from my profile?

[amitchandak]

@rnori_skyline , is it bucket or measure - "1-30"? To me, it seems like a measure and measure do pass filter on drill down.

[rnori_skyline]

Its a calculation item (measure based out of 1-30 days from selected date)..when i am drilling through, the date field is not filtering to be between 1 to 30 days