Forum Discussion

Krunalbpatel's avatar
Krunalbpatel
Helper III
10 years ago
Solved

Display different value on each drill down level

Hi,

 

I want to display different value on each drill down level. It means that I want to display sum value on First level and on second level I want to display the average value. Is It possible to display this in Power BI? If it is then How can I do this? 

 

Please Help me!

Thanks

  • konstantinos's avatar
    konstantinos
    10 years ago

    Krunalbpatel  You can try something like this 

     

    This is the table I create 

    FirstLevel	DrillLevel	Amount
A	C	5
A	D	5
A	C	5
B	F	5
B	F	5
B	E	5

    and the formula is 

     

    ChangeInDrillDown = 
     VAR  AverageCalc = AVERAGE(TableName[Amount])
     VAR  SumCalc   = SUM(TableName[Amount])

RETURN
IF(ISFILTERED(TableName[DrillLevel]);SumCalc;AverageCalc)

     

    Result 

     

     

     

3 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    Krunalbpatel what you can do is display sum and average side by side and as you drill down you see them both.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • konstantinos's avatar
    konstantinos
    Memorable Member
    10 years ago

    Krunalbpatel  You can try something like this 

     

    This is the table I create 

    FirstLevel	DrillLevel	Amount
A	C	5
A	D	5
A	C	5
B	F	5
B	F	5
B	E	5

    and the formula is 

     

    ChangeInDrillDown = 
     VAR  AverageCalc = AVERAGE(TableName[Amount])
     VAR  SumCalc   = SUM(TableName[Amount])

RETURN
IF(ISFILTERED(TableName[DrillLevel]);SumCalc;AverageCalc)

     

    Result