Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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% |
Solved! Go to Solution.
Like so?
Brand Avg = AVERAGE(Table1[PERCENT CHANGE])
Group Average = AVERAGEX( VALUES ( Table1[BRAND] ) , [Brand Avg] )
Like so?
Brand Avg = AVERAGE(Table1[PERCENT CHANGE])
Group Average = AVERAGEX( VALUES ( Table1[BRAND] ) , [Brand Avg] )
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:
PERFECT! Thanks for the quick response.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |