Forum Discussion
Drillthrough issue
Hey everyone,
I'm encountering an issue with my Power BI setup and could use some assistance. Currently, I have a date filter implemented using a slicer for the start date. However, my completed data relies on the following DAX expression to ensure accuracy within the specified period:
Completed Cal = CALCULATE (
[Completed Assess],
USERELATIONSHIP ( 'Fact'[Completed_Date], 'Date'[Date] )
)
The problem arises when I use this setup on a drillthrough page from the dashboard where the start date filter is active. It doesn't provide the correct data as it's still influenced by the start date filter. How can I adjust my drillthrough page to ensure it filters based on the completion date as defined in the USERELATIONSHIP, rather than the start date?
I've attempted several workarounds, including using a separate date table and establishing a direct relationship between the date table and the completed date, but none have resolved the issue. Any insights or suggestions would be greatly appreciated.
Ejy
That is a standard "shadow dataset" pattern. You need to have a disconnected and hidden copy of the table that the drillthrough is acting upon, and then use measures to project the drillthrough filter onto that shadow copy as needed.
1 Reply
That is a standard "shadow dataset" pattern. You need to have a disconnected and hidden copy of the table that the drillthrough is acting upon, and then use measures to project the drillthrough filter onto that shadow copy as needed.