Drillthrough is not showing data from other table

[Niels_T]

Hello,

I have a drillthrough on customer names to a different page with customer data.

The data on that particular page contains fields from the customer table and also fields from the credit memo + invoice table.

As you can see they are both connected to each.

The data also works correctly when I'm not drillingthrough.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[Niels_T]

@lbendlin 

I have a report with retour-data which is presented in a matrix with items -> customer in one column and in the other column the quantity of retours.

I would like to drill-through on customer to a different page with more detailed info about the customer.

On this page I use data of the customer-table and from the invoice-table.

On the right you can see that I added customer name to the drill-through filter. And this allows me to actually drill-through. 

All the info from the customer-table is then also visible, EXCEPT the invoice data. 

As you can see there is nothing under amount. I don't understand why as the tables are correctly connected and I use the customer table together with invoice table in other reports without any issue.

[lbendlin]

Please clarify what you mean by "correctly connected".  Is there a 1:* relationship between customer and invoice tables? Single filter direction?

[Niels_T]

Hello, 

Yes there is a 1:* relationship between the two tables. What exactly do you mean with single filter direction? There is only a drillthrough filter on the page where I have to drillthrough to and page filters, but these are not the cause of my problem.

[lbendlin · Accepted solution]

Sorry I had forgotten that you had posted the data model in the first post. Looks ok.

You have to be aware that Drillthrough by default operates on a single field filter being transported from one page to the other. Everything else (including the relationship to the parent table) has to be recreated manually - by you.

There is an option you can play with (" Keep all fiters" ) but it might actually be the opposite of what you seem to want to achieve.

Another option to consider is to sync slicers between the two pages.

[Niels_T]

So if I understood it correctly:

If I do a drill-through I only get to see the data of the parent-table and I can't see the data of other tables even if they are conntected?

[lbendlin]

yes, unless you do extra work (for example with the RELATED() trick of pulling in dimension attributes into the fact table.