Forum Discussion

rnori_skyline's avatar
rnori_skyline
New Member
4 years ago

Calculation Groups not able to filter date column

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:

 

 

5 Replies

    • rnori_skyline's avatar
      rnori_skyline
      New Member

      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

    • rnori_skyline's avatar
      rnori_skyline
      New Member

      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?