Forum Discussion

PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper II
2 years ago
Solved

Demo Challange Matrix

Hello Friends, Please refer link with DemoChallange.pbix file.   https://drive.google.com/drive/folders/1S4iOi_u6aBEK0bJOko_Zvw29SES8jjqS?usp=drive_link  Now, our challange is to display numbers i...
Need Help
Show and Tell
Tips and Tricks
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi PowerRobots99  I think I have Friday fatigue...

    Completed date =
     var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
      var lastweek = DATEADD(selDate,-7,DAY)
     var filDate =
     CALCULATETABLE( --modify filters
        FILTER(Data, [TransActualCompletionDate] > lastweek &&[TransActualCompletionDate] <= selDate)
        --only return rows after last week (excl 04) and to this week (inc 11/08)
        ,Data[ReportDate] = selDat--keep current report filter 
        )
     RETURN
     COUNTROWS(filDate)
SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

Hi PowerRobots99 

You need to change the report filter using Calculate and then add a filter based on the completion date using Filter (there are other methods). Create a measure like this:

 

Scheduled date =
 var selDate = LASTDATE(Data[ReportDate]) --Capture current Report Date
 var lastweek = DATEADD(selDate,-7,DAY)
 var filDate =
 CALCULATETABLE( --modify filters
    FILTER(Data, [TransScheduleCompletionDate] > lastweek &&[TransScheduleCompletionDate] <= selDate)
    --only return rows after last week (excl 04) and to this week (inc 11/08)
    ,Data[ReportDate] = lastweek--replace current report filter with last week
    )
 RETURN
 COUNTROWS(filDate)

 

 
PowerRobots99's avatar
PowerRobots99
Icon for Helper II rankHelper II
2 years ago

Hi SamWiseOwl,

 

I was trying to set up drill through for this table, but my filters are not passing through as we have modified the filters inside "Scheduled Date" measure.

 

Please let me know if there is any way to resolve this ?