Total of Variables Averages

[Anonymous]

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!!

[amitchandak · Accepted 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]

thanks @amitchandak , that worked!