Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |