Power Pivot model, and pivot table drill down limitation

alfalf

New Member
Joined
May 1, 2016
Messages
4
Hello,

I have actually a real basic need.

I have an excel file with a PowerPivot model that contains 1 fact table and 1 dimension table COUNTRY
1607593076988.png


1607593104888.png

I have basically created a pivot table on it :
1607593124994.png


When I want to drill down, by clicking on the value '10', it only displays the fields of the T_FACT_VOLUME table.
1607593194130.png

It makes sense, because it cannot expand all the model, so it focuses on the fact table.

But is there any possibility to change this behavior, and add some extra columns that comes from the dimensions tables (In this case I would want to have also the COUNTRY NAME in the table generated) ?
I have tried to edit the DAX behind the table, but the option is greyed out. :(



Thank you for your help

NB: Please note this is just a basic example, my real case is by far most complex. In this case I could just add the COUNTRY NAME in the pivot table (wihtout making any drilldown) and it would be fine of course.
But in a most complex real case with a lot of rows and columns, we need to be able to drilldown.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top