Average of summarize table

[crsjunior]

Hello,

I've create a table with DAX to group a sum by date, company and team. 

SUMMARIZE(

    table,
    table[company],
    table[team],
    table[date],
   "Available hours sum", SUM(table[available_hour])
)

In the same dax I want to use this created table to return the average of "Available hours sum" grouped by only company and team.

Appreciate any help.

[ryan_mayu · Accepted solution]

you can try to create table visual to get that.

if you can to create a table,what about change SUM to average?

SUMMARIZE(

    table,
    table[company],
    table[team],
   "Available hours sum", AVERAGE(table[available_hour])
)