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
pbeeyeqs
Helper I
Helper I

More help with Average of Averages

Having an issue trying to look at other possible solutions to assist with my issue. 

 

I want the results to show, for example:

AVG GROUP 1 takes the avg of the brand then avg's group. 

So, avg BRAND J = 8.4

avg BRAND K = 4.8

avg BRAND L = 4.9

 

AVG GROUP 1 would then = 6.03    NOT 6.6

This would then continue for all groups.

 

Thanks

 

GROUPBRANDPERCENT CHANGE
GROUP 1BRAND J4.8%
GROUP 1BRAND J12.0%
GROUP 1BRAND K4.8%
GROUP 1BRAND L4.9%
GROUP 2BRAND M8.0%
GROUP 3BRAND A4.0%
GROUP 4BRAND B8.0%
GROUP 4BRAND B15.0%
GROUP 4BRAND C8.0%
GROUP 4BRAND N7.0%
GROUP 5BRAND D5.0%
GROUP 5BRAND E4.0%
GROUP 5BRAND E6.0%
GROUP 5BRAND E6.0%
1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Like so?

Brand Avg = AVERAGE(Table1[PERCENT CHANGE])
Group Average = AVERAGEX( VALUES ( Table1[BRAND] ) , [Brand Avg] )

avg_averages.jpg

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User
Super User

Like so?

Brand Avg = AVERAGE(Table1[PERCENT CHANGE])
Group Average = AVERAGEX( VALUES ( Table1[BRAND] ) , [Brand Avg] )

avg_averages.jpg

One question -   what if I only wanted to show groups that had over 1 brand? So group 2 and 3 wouldn't show up. –

Write a measure like this.

Keep Row = 
VAR BrandCount = COUNTROWS ( VALUES ( Table1[BRAND] ) )
RETURN
IF ( BrandCount = 1, BLANK(), 1 )

Then add that measure as a visual filter and set it to [Keep Row] is 1:

keeprows.jpg

PERFECT! Thanks for the quick response. 

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.