Drillthough in Power BI between 2 tables with Indirect relationship

[patilpoonam21]

Hi,

I am trying to create a drillthrough bnetween 'Summary' and 'Detail' table but unable to create it.

Below is the sample model.

When I pull 'costcenter key' from summary table , I can see the drillthrough option. But I don't want to pull any 'key' column in the table. Is it possible?

Thanks,

Poonam

[danextian]

Hi @patilpoonam21  What do you mean by pull in this context? You should be able to use any column from Summary Table, Dim_Costcenter and DIM_Department to drillthrough Detailed_Table

[audreygerred]

Is the data in your summary table the same data as your detailed table, just at a higher level of granularity? If it is, you can just get rid of the summary table and use your detail table.