Calculation other than average

[Syndicate_Admin]

Good afternoon, I hope you are well, I wanted to ask for your help, since I can not reach the result, I have the following:

nuance

Rows:

• ASSET CLASS
• BACKGROUND FUND
• series

column:

• AUM Prom Jorge
• AUM Prom Period

First calculation:

AUM Prom Jorge = AVERAGE(Consolidado[Pat. MM$])

According to calculation:

AUM Prom Período = CALCULATE(

[AUM Prom Jorge],

filter(

Consolidated

Consolidated[Calculation Date]>=DATE(2021,05,01) && Consolidated[Calculation Date]<=DATE(2021,05,31)))

therefore it gives me the following result.

what enecesito that instead of the total me of the average, me of the total of the sum of the column, it is possible, I remain attentive, thank you very much.

[amitchandak · Accepted solution]

@Syndicate_Admin, Try measures like this measure

sumx(summarize(Consolidated, Consolidated[Asset Class],Consolidated[Fund],Consolidated[Series], "_1",AVERAGE(Consolidated[Pat. MM$])),[_1])