cancel
Showing results for
Did you mean:
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

 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%
1 ACCEPTED SOLUTION
Super User II

Like so?

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

4 REPLIES 4
Super User II

Like so?

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

Helper I

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

Super User II

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:

Helper I

PERFECT! Thanks for the quick response.

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.