Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Calculation other than average

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.

Mat.jpg

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.

  • @Syndicate_Admin, Try measures like this measure

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

1 Reply

  • @Syndicate_Admin, Try measures like this measure

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