cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Camicamomille Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Drillthrough / indirect relationship

@Camicamomille ,

 

Could you please share some sample data and give the expected result?

 

Regards,

Jimmy Tao

2 REPLIES 2
Community Support Team
Community Support Team

Re: Drillthrough / indirect relationship

@Camicamomille ,

 

Could you please share some sample data and give the expected result?

 

Regards,

Jimmy Tao

Camicamomille Frequent Visitor
Frequent Visitor

Re: Drillthrough / indirect relationship

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 410 members 4,125 guests
Please welcome our newest community members: