More help with Average of Averages

[pbeeyeqs]

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

GROUP	BRAND	PERCENT CHANGE
GROUP 1	BRAND J	4.8%
GROUP 1	BRAND J	12.0%
GROUP 1	BRAND K	4.8%
GROUP 1	BRAND L	4.9%
GROUP 2	BRAND M	8.0%
GROUP 3	BRAND A	4.0%
GROUP 4	BRAND B	8.0%
GROUP 4	BRAND B	15.0%
GROUP 4	BRAND C	8.0%
GROUP 4	BRAND N	7.0%
GROUP 5	BRAND D	5.0%
GROUP 5	BRAND E	4.0%
GROUP 5	BRAND E	6.0%
GROUP 5	BRAND E	6.0%

[jdbuchanan71 · Accepted solution]

Like so?

Brand Avg = AVERAGE(Table1[PERCENT CHANGE])

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

[pbeeyeqs]

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

[jdbuchanan71]

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:

[pbeeyeqs]

PERFECT! Thanks for the quick response.