Forum Discussion

addd123's avatar
addd123
Frequent Visitor
10 years ago
Solved

Drill down into different data

Hello,    Im trying not only switch the axis when drilling down, but also the values.    i.e. start with: Axis: Projects     Value: Total expenses   To   Axis: Employees     Value: Expense...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi addd123,

    I assume that you refer to this similar thread to write the above formula, right? If that is the case, firstly, there are syntax errors in the formula, please change it to the following formula, replace the columns(Table1[Amount]) and Table1[DrillLevel]) with your own fields. 

    ChangeInDrillDown =
     VAR  AverageCalc = AVERAGE(Table1[Amount])
     VAR  SumCalc   = SUM(Table1[Amount])
 
RETURN
IF(ISFILTERED(Table1[DrillLevel]),SumCalc,AverageCalc)


     Secondly, you can right click your table and choose “New Measure” to input the code.


    Thirdly, create clustered column chart, drag your own fields into Axis and drag ChangeInDrillDown into Value. For more details, please check the example in the attached PBIX file.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi addd123,

I assume that you refer to this similar thread to write the above formula, right? If that is the case, firstly, there are syntax errors in the formula, please change it to the following formula, replace the columns(Table1[Amount]) and Table1[DrillLevel]) with your own fields. 

ChangeInDrillDown =
     VAR  AverageCalc = AVERAGE(Table1[Amount])
     VAR  SumCalc   = SUM(Table1[Amount])
 
RETURN
IF(ISFILTERED(Table1[DrillLevel]),SumCalc,AverageCalc)


 Secondly, you can right click your table and choose “New Measure” to input the code.


Thirdly, create clustered column chart, drag your own fields into Axis and drag ChangeInDrillDown into Value. For more details, please check the example in the attached PBIX file.


Thanks,
Lydia Zhang