Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

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

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not 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