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.
Hello,
I have the following dataset with volumes by TIME and by BRAND:
I want to show the AVERAGE volumes by hour, with "Brand A" and "Brand B" combined together, like this:
The problem is that I want to show the total of "Brand A & B avg" highlighted in red not as the "Average of All" (above) but as "Average Brand A + Average Brand B" (below):
I'm using the measure Average( 'MyTable'[Volume] ) to calculate the averages and tried to add the functions ALL, ALLSELECTED, FILTER, KEEPFILTERS to properly show the totals, but no luck.
Any help is more than welcomed!
thanks!!
Solved! Go to Solution.
@Anonymous , refer if this can help
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
or like
sumx(summarize(table,table[brand],,"_1",Average( 'MyTable'[Volume] ) ),[_1])
@Anonymous , refer if this can help
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
or like
sumx(summarize(table,table[brand],,"_1",Average( 'MyTable'[Volume] ) ),[_1])
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 |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |