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
I have basically created a pivot table on it :
When I want to drill down, by clicking on the value '10', it only displays the fields of the T_FACT_VOLUME table.
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.
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
I have basically created a pivot table on it :
When I want to drill down, by clicking on the value '10', it only displays the fields of the T_FACT_VOLUME table.
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.
