Hi all,
I'm trying to create a drill-through from a summary matrix DAX measure into a details page. The measure itself has several filters applied in the DAX. One is where the date/time is BEFORE the minimal date value set for the date range of the report. This is to calculate an opening balance, which sums quantity on hand before the report date range. When clicking to the drill-through page, it will carry over the context/user defined filters from the matrix grid, but I need to implement the filters from the DAX on the details page so that the correct records show.
The main issue is with the date. The drill-through carries over a date filter from the summary page, which is the report range, but we only want records on the drill-through page which are before that min/first value of that date range.
Ex: Report filter is 4/1/2019 to 4//30/2019. Opening balance DAX value is summing quantity where date < 4/1/2019.
CALCULATE(SUM('Item'[Quantity]), FILTER(ALL('Item Status'[Status DateTime]),'Item Status'[Status DateTime] < MIN('Item Status'[Status DateTime]))
I'm trying to figure out how to create a new measure and apply the dynamic filter on the details/drill through page that will filter to only show records before the first selected date of the report range, which will show the actual opening balance transactions. Any ideas?
