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 the second Pie Chart should show the distribtion on all countries. Nevertheless I can not delete the drillthrough filter from the second pie chart because then it is also deleted from the first Pie Chart and the Drillthrough stops working.

 

Any Ideas on how I could solve this?

In the screenshot belows both Pie charts show the same filter, which I would like to change.

 

Thanks in advance

 

4 Replies

  • 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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Schullzki,

     

    Have you tried the solution provided by TomMartens above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards