Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Krunalbpatel
Helper III
Helper III

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

1 ACCEPTED SOLUTION
konstantinos
Memorable Member
Memorable Member

@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 

 

1.PNG

 

 

Konstantinos Ioannou

View solution in original post

3 REPLIES 3
konstantinos
Memorable Member
Memorable Member

@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 

 

1.PNG

 

 

Konstantinos Ioannou

@konstantinos Thank you for replying. I got my solution

ankitpatira
Community Champion
Community Champion

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

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors