Display different value on each drill down level

[Krunalbpatel]

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 · Accepted solution]

@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 

[Krunalbpatel]

@konstantinos Thank you for replying. I got my solution

[ankitpatira]

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