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...
Schullzki's avatar
Schullzki
New Member
9 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