Forum Discussion
Drillthrough / indirect relationship
Hi,
How could I make a drillthrough using an indirect relationship please?
Here is what I have:
- a page report with a bar chart, representing the number of products delivered by month
- a page report with a bar chart, representing the number of products manufactured by month, through a calculated value using the DAX formula "USE RELATIONSHIP"
The delivery date has a direct relationship with the calendar date (it is a custom one)
So I am able to drillthrough from the 1st page to a report page "Details" listing the products
The manufacturing date has a indirect relationship with the calendar date
And when I try to drillthrough from the 2nd page, it gives me the results with the month of the delivery date...
How could I make it drillthrough correctly please?
Thank you in advance,
Regards,
Camille
Anonymous ,
Could you please share some sample data and give the expected result?
Regards,
Jimmy Tao
2 Replies
- v-yuta-msft
Community Support
Anonymous ,
Could you please share some sample data and give the expected result?
Regards,
Jimmy Tao
- AnonymousNot applicable
Hi Jimmy,
Sorry I don't have some sample data.
I finally decided to make a second date table in order to solve my problem (I know, this is not very clean!)
Regards,
Camille