Forum Discussion

Schullzki's avatar
Schullzki
New Member
9 years ago

Drillthrough only on one visual

Hi Pro's,   I need your help...   I created a drillthrough page on which I want to show two Pie Charts. The first one should carry on the Filter (in my case the distribution on Country level) and...
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

due to the nature of the drillthrough page, you have to circumvent the effect you encounter by creating a separarate measure that you use on the pie chart that you want to show the whole value.

 

Drillthrough pages (for my explanation I will call them detail page) work like following. On the detail page you add a a column to the "Drillthrough filters" section. Now, whenever you select a value from this column on another page, the table is filtered in the context of the selected items.

 

If you want to circumvent this behavior by writing a separate measure by using something like this

the measure = 
CALCULATE(
  SUM('yourtable'[numeric column used on your piechart]
  ,ALL('table'[column used in drillthrough filters]
)

Hope this helps

 

Regards

Tom

Schullzki's avatar
Schullzki
New Member
8 years ago

Hi Tom,

 

thanks a lot for your reply. I tried to apply the proposed function but I am not super experienced yet and the formula always returns an error saying that "Too many arguments were passed to the sum function".

 

I am showing the ratio of Styles (Table: Product classification[Style]) based on the key figure Price (table: Sales Information[Price])

The drilldown filter is country in table: Sales Information[Country]. Therefore I used the following formula:

 

Drilldownprice =
CALCULATE(
SUM('Sales Information'[Price], ALL('Sales Information'[Country])))

 

Do you see why this is not working?

 

Thanks so much for the help

 

BR

Stefan

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    8 years ago

    Hey Schullzki,

     

    yes I see why my DAX statement wasn't working, I missed a 2 closing parentheses, here it is corrected, one for
    SUM( ... ) and for

    ALL( ... )

    the measure = 
CALCULATE(
  SUM('yourtable'[numeric column used on your piechart])
  ,ALL('table'[column used in drillthrough filters])
)

    Sorry for that

     

    Regards

    Tom