Forum Discussion
Drill Through Issue
I have two dates in my fact table Created Date and Solved Date. I have a few calculations that use both these fields. I have active relationship on CreatedDate to DimDate while I have inactive between Solved date and DimDate.
On my summary page with cluster column chart displaying created and solved cases against DimDate. Created Cases come from CreatedDate while Solved Cases come from a measure that uses USERELATIONSHIP().
Requirement: When I drill through to details page, both Createddate and the relevant Solved Dates should pass as drill through filters to details page.
Issue: Only Created Date passes to the details page. How do I pass the inactive relationship Dates(Solved Date) to drill through page.
Please suggest if you have any working recommendations. In case this is a known limitation, please direct me to the source/page.
Thanks in Advance,
Tharun.
On your summary page chart, don't use the Created Date but instead use dimDate. That way the dimDate will be passed through as a filter to your drill through page and you can use USERELATIONSHIP to activate the appropriate relationship in each measure.
I think the best option would be using separate role-playing date tables
- DimDateCreated → active to Fact[Created Date]
- DimDateSolved → active to Fact[Solved Date]
Then use the appropriate date field for the visual / drillthrough depending on whether you want Created or Solved context.If you need both independently, this is the most reliable pattern.
4 Replies
On your summary page chart, don't use the Created Date but instead use dimDate. That way the dimDate will be passed through as a filter to your drill through page and you can use USERELATIONSHIP to activate the appropriate relationship in each measure.
I think the best option would be using separate role-playing date tables
- DimDateCreated → active to Fact[Created Date]
- DimDateSolved → active to Fact[Solved Date]
Then use the appropriate date field for the visual / drillthrough depending on whether you want Created or Solved context.If you need both independently, this is the most reliable pattern.
Hi Tharun95,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
cengizhanarslan & johnt75 ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportHi @Tharun95,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
